Using LINQ to SQL with multiple databases

Posted by Stuart Ferguson on Stack Overflow See other posts from Stack Overflow or by Stuart Ferguson
Published on 2010-05-07T09:10:19Z Indexed on 2010/05/10 7:04 UTC
Read the original article Hit count: 487

Filed under:

linq-to-sql

|

inheritance

I am working on a new project and hoping to use LINQ to SQL for the data access but have come across the following issue.

I need to have my application access 3 databases with similar but not the same table structure, for example

Database1 and Database 2 has a table called tblCustomer with 2 columns CustomerKey and CustomerName

Database2 has a table called tblCustomer with 3 columns CustomerKey, CustomerName and CustomerPostCode

I am looking for a solution that will allow me a query all three databases without the need for 3 GetCustomerList functions as Database1 and Database2 could use the same function as are the same structure, with an override function for database 3 to bring back the additional field.

Is there a way i can declare a base datacontext class to handle Database 1 and 2 with an inherited version for Database 3.

Thanks In Advance

Stuart Ferguson

© Stack Overflow or respective owner

Related posts about linq-to-sql

how can i page my linq to sql result set

as seen on Stack Overflow - Search for 'Stack Overflow'
Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included. Select * FROM Users Limit [start], [Length] How can I do this in LinqToSql >>> More
LINQ to SQL and missing Many to Many EntityRefs

as seen on West-Wind - Search for 'West-Wind'
Ran into an odd behavior today with a many to many mapping of one of my tables in LINQ to SQL. Many to many mappings aren’t transparent in LINQ to SQL and it maps the link table the same way the SQL schema has it when creating one. In other words LINQ to SQL isn’t smart about many to many mappings… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
LINQ to SQL Profiler

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections… >>> More

Related posts about inheritance

Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it us

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I study about today about 2 database design inheritance approaches: 1. Single Table Inheritance 2. Class Table Inheritance In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table. But i read that the more favorite approach… >>> More
How to use Private Inheritence aka C++ in C# and Why not it is present in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I know that private inheritance is supported in C++ and only public inheritance is supported in C#. I also came across an article which says that private inheritance usually defines a HAS-A relationship and kind of an aggregation relationship between the classes. EDIT: C++ code for private inheritance: The… >>> More
[PHP] Singleton class and using inheritance

as seen on Stack Overflow - Search for 'Stack Overflow'
I have am working on a web application that makes use of helper classes. These classes hold functions to various operation such as form handling. Sometimes I need these classes at more than one spot in my application, The way I do it now is to make a new Object. I can't pass the variable, this will… >>> More
Difference between Inheritance and Composition

as seen on Stack Overflow - Search for 'Stack Overflow'
Are Composition and Inheritance are the same? If I want to implement the composition pattern, how can I do that in Java? >>> More
C# Interface Inheritance (Basics)

as seen on Stack Overflow - Search for 'Stack Overflow'
Why does the following produce a compiler error: public interface OwnSession : ISession { } [...] OwnSession s = SessionFactory.OpenSession(); // compiler error (in german unfortunately) [...] "SessionFactory" returns a "ISession" on "OpenSession()" (NHibernate) >>> More