LinqToSQL: Query Multiple Databases in One LINQ Expression and More...

Muigai Mwaura

Rate me:

4.11/5 (8 votes)

31 Jan 2008LGPL35 min read

85.2K

918

Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database

linqtosql.zip
- LinqToSQL
  - LinqToSQL.sln
  - LinqToSQL.suo
  - NorthwindLinq
    - app.config
    - bin
      - Release
    - Evaluator.cs
    - ExpressionVisitor.cs
    - LinqToSQL.csproj
    - LinqToSQL.csproj.user
    - ObjectDumper
      - bin
        
        Release
        
        ObjectDumper.dll
        
        ObjectDumper.pdb
      - ObjectDumper.cs
      - ObjectDumper.csproj
      - ObjectDumper.csproj.user
      - Properties
        
        AssemblyInfo.cs
    - Properties
    - Query.cs
    - select.txt
    - SQLExpressionParser.cs
    - SQLQueryProvider.cs
    - ThreadSafeCache.cs
    - TypeSystem.cs
    - ve-1C.tmp
  - NorthwindLinqTest
    - app.config
    - bin
      - Debug
        
        CustomerInformation.mdb
        
        FavouriteDVD.mdb
        
        Northwind.ldb
        
        Northwind.mdb
        
        ObjectDumper.dll
      - Release
    - NorthwindClasses.cs
    - NorthwindLinq.cs
    - NorthwindLinq.csproj
    - NorthwindLinq.csproj.user
    - NorthwindLinq.Designer.cs
    - NorthwindLinq.resx
    - NorthwindLinqTest.csproj
    - Program.cs
    - Properties

<?xml version='1.0' encoding='utf-8'?>
<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="NorthwindLinqTest.Properties" GeneratedClassName="Settings">
  <Profiles />
  <Settings>
    <Setting Name="SQLProvider" Type="System.String" Scope="Application">
      <Value Profile="(Default)">System.Data.SqlClient</Value>
    </Setting>
    <Setting Name="Northwind_SqlConnectionString" Type="System.String" Scope="Application">
      <Value Profile="(Default)">Data Source=.\SQLEXPRESS;database="NorthWind";Integrated Security=True;Connect Timeout=30</Value>
    </Setting>
    <Setting Name="AccessProvider" Type="System.String" Scope="Application">
      <Value Profile="(Default)">System.Data.OleDb</Value>
    </Setting>
    <Setting Name="Northwind_AccessConnectionString" Type="System.String" Scope="Application">
      <Value Profile="(Default)">Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb;</Value>
    </Setting>
  </Settings>
</SettingsFile>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The GNU Lesser General Public License (LGPLv3)

Written By

Muigai Mwaura

Technical Lead Olivine Technology

Kenya

Technical Lead, Olivine Technology - Nairobi, Kenya.

"The bane of productivity: confusing the rituals of work (sitting at your desk by 8:00am, wearing a clean and well pressed business costume etc.) with actual work that produces results."

Watch me!

LinqToSQL: Query Multiple Databases in One LINQ Expression and More...

License

Comments and Discussions