Building a service on a "not well-known" database...

Question

Hi there,

 My question seems stupid, and I can't figure out a workaround to do that, however I ask it anyway. I work on a tool based on a Access or Sql Server (and later Oracle) database, a part of which is known (the System part), the other part (the Client part) being created and modified later by the admin user. The "client" part is described with xml fields values in the "system" part. The client part is made of simple table with no foreign keys.

 Now how can I build a ADO.NET Data service and map the all database schema with .net classes ? Can I use a sort of "reflection" process to build the Context  object ?

 Best regards

Answer 1

ADO.Net Data Services supports reflection based models, but depending on which data patterns you have "used", you might need to "write" some kind of facade between Astoria and your "system".