Configurable Table Prefixes with a .Net OR/M?,
In a web application like wiki or forums or blogging software, it is often useful to store your data in a relational database. Since many hosting companies offer a single database with their hosting plans (with additional databases costing extra) it is very useful for your users when your database objects (tables, views, constraints, and stored procedures) have a common prefix. It is typical for applications aware of database scarcity to have a hard-coded table prefix. I want more, however. Specifically, I’d like to have a table prefix that users can designateâ€”say in the web.config file (with an appropriate default, of course).
Since I hate coding operations by hand, I prefer to work through a competent OR/M and have used (and enjoyed) LINQ to SQL, Subsonic, and ADO.Net. I’m having some thrash in a new project, however, when it comes to putting a table prefix in a user’s web.config file. Are there any .Net-based OR/M products that can handle this scenario elegantly?
The best I have been able to come up with so far is using LINQ to SQL with an external mapping file that I’d have to update somehow based on an as-yet hypothetical web.config setting.
Anyone have a better solution? I tried to make it happen in Entity Framework, but that turned into a mess quickly. (Due to my unfamiliarity with EF? Possibly.) How about SubSonic? Does it have an option to apply a table prefix besides at code generation time?
I’ve now researched what it takes to do this in both Entity Framework and LINQ to SQL and It’s much longer than answers here tend to be so I’ll be content with a link to the answer rather than duplicate it here. It’s relatively involved for each, but the LINQ to SQL is the more flexible solution and also the easiest to implment.
That’s the answer Configurable Table Prefixes with a .Net OR/M?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.
The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you