Jun 29 2016

Easiest way to import CSV files

Greetings to all readers. Let us discuss a very commonly faced issue in this blog, import of data into a database through a program. Programmers and client organisations equally dread the upload of legacy data into the database while installing new software systems as well as modifying existing systems. Even in day to day applications […]

Mar 29 2016

How to Maintain Consistency in SQL Tables using Linq

In .NET Framework, Transactionscope is an important class. Transaction is used under a set of short and quick tasks. If any of these tasks fails, the whole transaction should fail and all those tasks already done should rollback. Actually, in code, Transactionscope makes it transactional. For using Transactionscope, we can use the namespace, System.Transactions.TransactionScope. Transaction […]

Feb 24 2016

Export data from SQL Server to excel

In this article we will focus on how to export data from SQL Server Tables to an Excel file. The data from SQL Server is first fetched into a DataTable and this Datatable will be exported to an Excel Sheet. There are different methods for data exporting to various format, but all depends on the […]

Feb 23 2016

Processing data from SQL DB – a linq solution

There are different ways in which an application can access the underlying database and a programmer can use any of these according to her convenience. It could be a stored procedure or frameworks like ADO.NET or ADO.NET Entity Framework using which a client application interact with data. I would like to share with you some […]

Feb 22 2016

Handling Huge Number of Parameters in SQL Procedure

As we know, stored procedure has the ability to be executed faster than the same set of T-SQL statements containing the same logic. This is because the query execution plan for stored procedures is recorded and stored in the sysprocedures system table (in binary format). In my application, I use a number of stored procedures […]

Dec 23 2015

Switching multiple datacontext at runtime using injectionfactory

As you know, I have recently become a huge fan of the Dependency Injection (DI) and unity injectionfactory because of which i had solved one huge problem in a very simple way. I'm using CodeFirst and I've got a project which involves different DbContexts and accessing different parts of the database. Now when I access […]

Dec 1 2015

MANUALLY ADDING INDEXES IN SQL SERVER

Here i am explaining about the indexes in sql server, that is how to create indexes and its differences. Sql server index is a database object , Index will make data retrieval more effectively. it will increase the performance of data retrieval and it will make some overhead on data crud operations such as create […]

Dec 1 2015

Data Migration between Tables, A Painless Method

Data Migration Data Migration is the process of transferring data from one system to another while changing the storage, database or application. In most of the cases, data migration occurs during an upgrade of existing system to a completely new system. Example Two components mergers: When the parallel systems in the two components need to […]

Nov 23 2015

Solving controversies during Drop, Truncate and Delete functions

While doing my project, I got an issue where i couldn't truncate or delete my table that contained foreign key relation. I could have used cascade delete on that table for deleting but instead i created the foreign key table without cascade delete. So I wanted to share about what are the issues while dropping, […]

Nov 23 2015

Relationship between schema and tables in sql

The persistent elements of an SQL are database objects. A database object in a relational database is a data structure used to either store or reference data, schema . A schema is a logical definition of a table – it defines what the name of the table is, and what the name and type of […]

<< Next