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


Microsoft Visual Studio Solution File, Format Version 10.00
# Visual C# Express 2008
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "LinqToSQL", "NorthwindLinq\LinqToSQL.csproj", "{CF109708-DADA-4BCF-A61C-6593D30DC7A1}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ObjectDumper", "NorthwindLinq\ObjectDumper\ObjectDumper.csproj", "{D2BE27AE-A151-4259-931A-D95B906E10B6}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "NorthwindLinqTest", "NorthwindLinqTest\NorthwindLinqTest.csproj", "{1DFAAFE4-5D5E-4960-8C1A-63F35547ECCB}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{CF109708-DADA-4BCF-A61C-6593D30DC7A1}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{CF109708-DADA-4BCF-A61C-6593D30DC7A1}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{CF109708-DADA-4BCF-A61C-6593D30DC7A1}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{CF109708-DADA-4BCF-A61C-6593D30DC7A1}.Release|Any CPU.Build.0 = Release|Any CPU
		{D2BE27AE-A151-4259-931A-D95B906E10B6}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{D2BE27AE-A151-4259-931A-D95B906E10B6}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{D2BE27AE-A151-4259-931A-D95B906E10B6}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{D2BE27AE-A151-4259-931A-D95B906E10B6}.Release|Any CPU.Build.0 = Release|Any CPU
		{1DFAAFE4-5D5E-4960-8C1A-63F35547ECCB}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{1DFAAFE4-5D5E-4960-8C1A-63F35547ECCB}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{1DFAAFE4-5D5E-4960-8C1A-63F35547ECCB}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{1DFAAFE4-5D5E-4960-8C1A-63F35547ECCB}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

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