Link Details

Recently i was working on a project where application performance was a top priority. I started looking into ORM frameworks and found that ORMs are great for most applications, but when performance is a factor it�s best to write your own data access. So that's when I decided to write my own data access. This article will explain some of the design that i have used in my project. I have used SqlDataReader�s strongly typed Get methods to do a null check and then write the values. Here is my base class in VB.NET.

Posted by farooq.kaiser  |   Jun 13 2012 / 07:20

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Comments

User 840261 avatar

Yurik Tyrant replied ago:

No need to write your own code. LINQ to SQL will populate your classes for you. Just decorate your fields with Attributes matching the columns.

Reply 0 votes
User 439576 avatar

farooq.kaiser replied ago:

Have you read the article? LINQ to SQL won't give you the performance. Take a look benchmark here. http://www.luisrocha.net/2011/12/data-access-performance-comparison-in.html

Reply 0 votes

Recommended Links

Scala
Written by: Ryan Knight
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Play
  3. Akka
  4. Debugging JavaScript
  5. Design Patterns
  1. Apache Hadoop
  2. REST
  3. Java
  4. Git
  5. Java Performance
Connect with DZone