Where locking causes problems with queries it can be useful to execute those queries with the NOLOCK hint. This specifies that a query should ignore existing locks and create no data locks. However, the hint introduces the potential of data corruption.

It's been bottled up inside me for 10 years, I'm finally going to say whats on my mind regarding the Industry and Databases, take it or leave it

Recently one of my friend was needed only first three rows of data table and so he asked me and I have multiple solutions for that. So thought it would be great idea to share with you guys. Possible Solutions to problem: There are two ways to solve this problem. With normal for loop With lamd...

how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object

The repository pattern has been discussed a lot lately. Especially about it's usefulness since the introduction of OR/M libraries. This post (which is the third in a series about the data layer) aims to explain why it's still a great choice.

ADO.NET is actually quite powerful if you use it correctly. This post will teach you everything from making your ADO.NET code driver independent to how to implement the repository pattern and unit of work. This is the follow up post of my “Datalayer, the right way” post. The purpose is to demonstrat...

The goal with this post is to give you a better understand about how you can design your data layer and why it’s important to create a complete abstraction layer.

Few days back I was optimizing the performance with Entity framework and Linq queries and I was using LinqPad and looking SQL generated by the Linq or entity framework queries. After some point of time I got the same question in mind that how I can find the SQL Statement generated by Entity framewor...

Network packets are human-readable using a packet sniffer when SQL results passing between client machine and SQL server. Tabular Data Stream(TDS) is the protocol used by SQL server to form packets to be sent through the network. This post explains the steps to encrypt a session with SSL in SQL Ser...

DataReader is known for the best performing option to retrieve data, yet you can do a couple of things to make it even faster.

Implement Repository Pattern in data access layer with Entity Framework 4.0 and Below version( Working with ObjectContext and EntityObject )

I did talk about the distributed architecture on my previous post with Entity framework code-first. Now I would like to reminds you about the performance benefit features come with DBContext and it will also help you to extend your repositories and queries.

EFLookup adds support for lookup value tables when using an Entity Framework DbContext. Lookup values are treated as entities, offering capabilities far beyond the enum support added in EF 5. EFLookup provides simple definition of lookup tables, standard lookup fields such as Code, Name, Description...

I was curious about change tracking and property values of DbContext and while playing with that I decided to write snapshot manager which would take snapshot of my each changes by storing entries And this manager also allow me to backward and forward my changes with DbContext. The Undo and Redo fea...