user204588
user204588

Reputation: 1633

.net generate class from database table runtime

I'm not finding an ORM that does this for .net 2.0 (i know it's old but some clients still use it)... anyway, I want to generate a class or properties from a sql query at runtime and use it. So, I use subsonic now and I generate the classes and then add them to my project..etc and this is great for objects I'm using all the time but sometimes for quick queries I want to be able to do something like this:

QueryClass result = ...(SELECT * FROM)
...SHOW(result.Column1, result.Column2)

So, above isn't real code but I want it to work like this. Anyone point me in the right direction?

Upvotes: 0

Views: 257

Answers (1)

qxn
qxn

Reputation: 17584

Can you use a Dictionary?

Dictionary<string, object> result = ...(SELECT * FROM)
...SHOW(result["Column1"], result["Column2"])

Upvotes: 1

Related Questions