subsonic3 - Use subsonic 3.0 SimpleRepository to a existing database

Question

I want to use subsonic 3.0 SimpleRepository in my project, but there is a problem :

If my table's name like Product etc. then I can't get any data from database, because subsonic generate the sql statement like "Select * from Products ..."

PS: I don't want to change my table name.

I wrote a t4 template to solve this problem, I hope someone can take a look at my code and tell me am i do the right thing?

Code: SimpleRepositoryDemo

Answer 1

It sounds like you already have a database designed in which case I would suggest you use the LinqTemplates or ActiveRecord instead. SimpleRepository seems to really be suited to a code first development process rather than a database first.