c# - O/R-map a single arbitrary SQL SELECT statement to a single class? -

i don't know mechanics of how orm tools work, working entity framework (ef), know it's somehow possible auto-generate clr classes arbitrary views stored in database. in ef these classes auto-generated entity model. ef can column information stored procedure , generate new "complex type" information.

• how possible auto-generate .net classes, using (1) information provided sql select statement , (2) ability query database metadata?

because sql stored in database, know @ compile time select sql is. similarly, entity framework knows view or stored procedure's select sql @ compile time. want auto-generate .net classes knowing select sql , querying database's metadata. need able transform resulting single datatable auto-generated classes.

it seems answer question lies in having knowledge of orm tools;

• is there orm tool out there can need, or
• could explain how entity framework auto-generates .net classes views , stored procedures?
• or if can come solution auto-generating classes scenario, appreciated.

if clarification needed, let me know.

metadata tables , views loaded system views: sys.tables, sys.views, sys.columns , others.

edit:

i tested how ef gets column names , types , indeed executes stored procedure , iterates on returned columns. uses complex queries correctly build call command , handle return value.