Link Details

Link 805971 thumbnail
User 439576 avatar

By farooq.kaiser
via fairnet.com
Published: Jun 13 2012 / 07:20

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.
  • 5
  • 1
  • 672
  • 467

Comments

Add your comment
User 840261 avatar

Yurik Tyrant replied ago:

0 votes Vote down Vote up Reply

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.

User 439576 avatar

farooq.kaiser replied ago:

0 votes Vote down Vote up Reply

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

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.

Voters For This Link (5)



Voters Against This Link (1)



Debugging JavaScript
Written by: Ashutosh Sharma
Featured Refcardz: Top Refcardz:
  1. Design Patterns
  2. OO JS
  3. Cont. Delivery
  4. Java EE7
  5. HTML5 Mobile
  1. Java EE7
  2. Spring Annotations
  3. Git
  4. Java
  5. REST