Custom SQL Queries and SubSonic ActiveRecord?

Question

I'm needing to do some SQL queries manually because ActiveRecord doesn't support any kind of XPath query.

I'd love if I could somehow send in a query and it give me back a list of data objects. What would be the easiest way to do this without manually loading each column into an object's property

score 1 · Answer 1 · answered Jun 10 '11 at 14:14

1

SubSonic has a "CodingHorror" class which enables me to do inline queries and it has a method ExecuteTypedList<T>(). So I'm going to try loading things that way and see how it works

answered Jun 10 '11 at 14:14

Earlz

62,085
98
303
499

score -1 · Answer 2 · edited May 23 '17 at 12:12

-1

So you need to load xml into c# objects?
Sounds like this maybe...

How do I map XML to C# objects

edited May 23 '17 at 12:12

Community

1
1

answered Jun 09 '11 at 23:59

Sam

7,543
7
48
62

No, I need to query my database using XPath(only in the where clause) and load the result into standard SubSonic objects. – Earlz Jun 10 '11 at 14:12

Custom SQL Queries and SubSonic ActiveRecord?

2 Answers2