By tag: database
0
kicks
Say no to the repository pattern in your DAL
Software development goes in cycles, just like everything in the universe and we find ourselves at this point again. We see developers touting the benefits of using the repository pattern for internal data access over leveraging the tools and APIs specific to their technology of choice. So let me ba...
0
kicks
SQL Server NOLOCK Hint
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.
0
kicks
Pervasive Myths, Databases and Development - A Series
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
0
kicks
How to get N row from datatable in C#
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...
0
kicks
Database Change Notifications in ASP.NET using SignalR and SqlDependen
how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object
0
kicks
Repository pattern, done right
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.
0
kicks
ADO.NET, done right
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...
0
kicks
Data layer, the right way
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.
0
kicks
Where I can find SQL Generated by Entity framework?
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...
0
kicks
Encrypting the session with SSL in SQL Server
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...
0
kicks
SqlDataReader’s GetInt32() and GetOrdinal(), and their Performance
DataReader is known for the best performing option to retrieve data, yet you can do a couple of things to make it even faster.
0
kicks
Implementing Repository Pattern With Entity Framework
Implement Repository Pattern in data access layer with Entity Framework 4.0 and Below version( Working with ObjectContext and EntityObject )
0
kicks
Getting Performance Benefit From DbContext[EF 5] of Entity Framework
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.
0
kicks
EFLookup - Library for creating lookup tables in Entity Framework
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...
0
kicks
Implementing Undo/Redo feature for DbContext of Entity Framework Code-
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...