Configurable Table Prefixes with a .Net OR/M?

Question :

Configurable Table Prefixes with a .Net OR/M?,

Answer :

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).

Read More  C# 2.0 code consuming assemblies compiled with C# 3.0

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.

Read More  Best implementation for Key Value Pair Data Structure?

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.

Read More  How have Html entities inside page?

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.

Disclaimer :

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