LinqToSQL: Comprehensive Support for SQLite, Microsoft Access, SQServer2000/2005

Muigai Mwaura

Rate me:

4.97/5 (19 votes)

12 Feb 2008LGPL35 min read

176.5K

2.7K

111

Use LinqToSql to query these popular RDMS products

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
    - SQLSyntaxHelper.cs
    - ThreadSafeCache.cs
    - TypeSystem.cs
    - ve-1C.tmp
  - NorthwindLinqTest
    - app.config
    - bin
      - Release
        
        NorthwindLinq.dll
        
        NorthwindLinq.pdb
        
        NorthwindLinqTest.exe
        
        NorthwindLinqTest.exe.config
        
        NorthwindLinqTest.pdb
        
        ObjectDumper.dll
        
        ObjectDumper.pdb
    - 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="NorthwindLinq.Properties" GeneratedClassName="Settings">
  <Profiles />
  <Settings>
    <Setting Name="Northwind_2007_03_29SQLConnectionString" Type="(Connection string)" Scope="Application">
      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
  &lt;ConnectionString&gt;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBML\Northwind_2007-03-29SQL.mdf;Integrated Security=True;MultipleActiveResultSets=True;Connect Timeout=30;User Instance=True&lt;/ConnectionString&gt;
  &lt;ProviderName&gt;System.Data.SqlClient&lt;/ProviderName&gt;
&lt;/SerializableConnectionString&gt;</DesignTimeValue>
      <Value Profile="(Default)">Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBML\Northwind_2007-03-29SQL.mdf;Integrated Security=True;MultipleActiveResultSets=True;Connect Timeout=30;User Instance=True</Value>
    </Setting>
    <Setting Name="Northwind_2007_03_29SQLConnectionString1" Type="(Connection string)" Scope="Application">
      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
  &lt;ConnectionString&gt;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind_2007-03-29SQL.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True&lt;/ConnectionString&gt;
  &lt;ProviderName&gt;System.Data.SqlClient&lt;/ProviderName&gt;
&lt;/SerializableConnectionString&gt;</DesignTimeValue>
      <Value Profile="(Default)">Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind_2007-03-29SQL.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True</Value>
    </Setting>
    <Setting Name="Provider" Type="System.String" Scope="Application">
      <Value Profile="(Default)">System.Data.SqlClient</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: Comprehensive Support for SQLite, Microsoft Access, SQServer2000/2005

License

Comments and Discussions