Linq To SQL - how to have property not from table but from DB

Question

We are using Linq To SQL with our own data context logic that executes the one linq query across multiple databases. When we get the results back, we need the database for each of the rows. So...

I want to have a property on my class that will return the database name (SQL Server, so DB_NAME()). How can I do this in Linq To Sql?

NOTE: We have hundreds of databases and do not want to put views in each db. The return should come back as just another property on each row of the return result set.

can you provide more details on how you're querying against multiple databases? is this done within the application, from the database server via a stored procedure, or how? — Mark Cidade
– Mark Cidade, Commented Oct 23, 2008 at 21:05

Mark Cidade · Accepted Answer · 2008-10-23 22:32:05Z

2

In the DBML XML file, you can set the Expression attribute of a Column element to this:

 <Column Name="Table1.DBName" 
         DbType="nvarahcar(128)" 
         Type="System.String" 
         Expression="DB_NAME()" />

answered Oct 23, 2008 at 22:32

Mark Cidade

100k33 gold badges231 silver badges238 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gfrizzle · Accepted Answer · 2008-10-23 20:52:32Z

0

How are you iterating through the different databases? Could you just include information from the context in the query? For example:

Dim results = _
    From x In myContext.MyTables _
    Select x, info = myContext.Connection.ConnectionString

answered Oct 23, 2008 at 20:52

gfrizzle

12.7k20 gold badges81 silver badges104 bronze badges

Collectives™ on Stack Overflow

Linq To SQL - how to have property not from table but from DB

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related