What should be the default behavior of LINQ-to-Entities while setting the default value of a field in SQL’s field designer ? Sometimes it’s difficult to come up with a topic that we feel inspired to write about. I am writing about the problem I encountered while working with entity datamodel. After discussing with the team […]

here are some applications where we need to display large sets of data. In order to display this large sets of data we usually follow the approach of Data paging. In asp.net there are data bound controls like Gridview, listview etc that can facilitate paging. The problem with this databound controls is that they perform […]

While interacting with Database, use of Transaction is a very helpful approach particularly when the DB interaction involves inserting/updating/fetching data on more than one table structure. A set of DB tasks grouped into a single execution unit is refferd as a Transaction unit. If all the tasks completed successfully then the transaction completes and if […]

If you are having an application that executes structurally similar queries many times in the Entity Framework, you can increase the performance by compiling the query once and executing it several times with different parameters. For example if you are building a web application which is going to get thousands of hit per hour by […]