Custom ORM in .NET

tags:

.net
orm

views:

answers:

Custom ORM in .NET

Hi I want to call only stored procedures on database and fill my C# object according to the result. I just need a mapping file, and a fast reflection tool like Fasterflect found on CodePlex to create my own ORM.

Is there any ORM available with these feature for C# which has lightning fast performance ? or what should I do to complete the above scenario in terms of mapping database objects ??

+3 A:

Hey,

There are several implementations of .NET ORMs.

The framework already has two, Linq to Sql and Entity Framework. What type of database are you trying to target?

If you are looking for open source implementations check out

NHibernate

I really wouldn't try building one yourself unless you have plenty of time! Most ORMs have a huge feature list.

I have used a product called LightSpeed from Mindscape. It support multiple rdbms, has a fantastic designer, superb linq capabilities and provides great performance.

Rohan West 2010-08-26 01:59:57

+1 agreed; there are existing ORMs like NHibernate or Entity Framework that can call stored procedures just fine; don't recreate the wheel when there are great ones out there already

Tahbaza 2010-08-26 02:03:56

NHibernate and Entity Framework is very heavy but complete. there are several benchmarks out there that shows these frameworks has low performance compared to other available frameworks like DataObject.NET

Ehsan 2010-08-27 19:55:36

LightSpeed is great and the performance section of this product is exactly what I'm looking for but i need an open source

Ehsan 2010-08-27 19:59:19

Fluent Ado.Net

Catalin DICU 2010-08-26 02:02:17

Fluent Ado.Net isn't an ORM, it is simply a wrapper that sits on top of ADO.Net

Rohan West 2010-08-26 02:10:47

@Rohan West: see SetMap()

Mauricio Scheffer 2010-08-26 02:22:15

@Mauricio Scheffer: Set map is a method that accepts a function that defines how a SqlDataReader should be used to create an instance of the desired object. This is just adding a wrapper to ADO.Net, it dosn't provide any functionallity typically associated with an ORM

Rohan West 2010-08-26 02:48:18

@Rohan West: that's what I understand the OP wants: a *simple* mapper. SetMap() is just that, a mapper as simple as it gets.

Mauricio Scheffer 2010-08-26 03:14:55

ansaurus

tags:

views:

answers:

Custom ORM in .NET

related questions