Is there any .net ORM that doesn't need classes?

Asked Dec 13 '16 at 10:20

Active Dec 13 '16 at 10:20

Viewed 59 times

Is there something like this in .net? https://laravel.com/docs/5.3/queries

//sample query
var users = DB::table('users')->select('name', 'email as user_email')->get();

And since this ORM doesn't need classes, I'm thinking it should return a List<Dictionary<string,object>> instead of List<User> where I can access the values via:

foreach(var user in users){
    //something like this
    Console.WriteLine("my name is "+user["name"]);
}

asked Dec 13 '16 at 10:20

anaval

1,130
10
24

2

You can do this with Dapper for example (see this answer: http://stackoverflow.com/a/6161472/5311735). – Evk Dec 13 '16 at 10:23
@Bas but EF needs me to define classes. Most of my tables have more than 100 columns – anaval Dec 13 '16 at 10:25
Use PetaPOCO or Dapper, these are micro ORM which can fulfill your requirements. – Abhay Dixit Dec 13 '16 at 10:32

Is there any .net ORM that doesn't need classes?

0 Answers0