Click here to Skip to main content
15,895,084 members
Articles / Database Development / SQL Server

Creating a Private Installation for SQL Compact

Rate me:
Please Sign up or sign in to vote.
4.83/5 (30 votes)
24 Sep 2010CPOL9 min read 139K   2.6K   75  
This article discusses how to create a private installation for SQL Compact
  • source_code.zip
    • SqlCompactPrivateInstallDemo
      • _ReSharper.SqlCePrivateInstallDemo
        • BuildScriptCache
          • .crc
          • .version
          • 4
          • 5
            • 6ac5cd40.dat
          • 7
          • 8
          • 9
        • DecompilerCache
        • ModuleIds.xml
        • NamedArguments
          • .crc
          • .version
          • 8
            • 2c920727.dat
        • PdbInfo
        • ProjectModel
          • ProjectModel.dat
        • Resources
          • .crc
          • .version
          • 8
            • 2c920727.dat
        • SymbolCache.bin
        • TagPrefixes
          • .crc
          • .version
        • TodoCache
          • .crc
          • .version
          • 8
            • 2c920727.dat
        • WebsiteFileReferences
          • .crc
          • .version
        • WordIndex
          • .crc
          • .version
          • 8
            • 2c920727.dat
      • _ReSharper.SqlCompactPrivateInstallDemo
        • BuildScriptCache
          • .crc
          • .version
        • DecompilerCache
        • NamedArguments
          • .crc
          • .version
          • 7
            • 74d5c15c.dat
        • PdbInfo
        • ProjectModel
          • ProjectModel.dat
        • Resources
          • .crc
          • .version
        • SymbolCache.bin
        • TagPrefixes
          • .crc
          • .version
        • TodoCache
          • .crc
          • .version
        • WebsiteFileReferences
          • .crc
          • .version
        • WordIndex
          • .crc
          • .version
      • Libraries
        • SqlCompact
          • AMD64
            • sqlceca35.dll
            • sqlcecompact35.dll
            • sqlceer35EN.dll
            • sqlceme35.dll
            • sqlceoledb35.dll
            • sqlceqp35.dll
            • sqlcese35.dll
          • System.Data.SqlServerCe.dll
          • System.Data.SqlServerCe.Entity.dll
          • X86
            • sqlceca35.dll
            • sqlcecompact35.dll
            • sqlceer35EN.dll
            • sqlceme35.dll
            • sqlceoledb35.dll
            • sqlceqp35.dll
            • sqlcese35.dll
      • SetupDemo
        • SetupDemo.vdproj
      • SqlCePrivateInstallDemo.5.1.ReSharper.user
      • SqlCompactPrivateInstallDemo.5.1.ReSharper.user
      • SqlCompactPrivateInstallDemo.sln
      • SqlCompactPrivateInstallDemo.suo
      • SqlCompactPrivateInstallDemo
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="LocalDataEntities" connectionString="metadata=res://*/LocalData.csdl|res://*/LocalData.ssdl|res://*/LocalData.msl;provider=System.Data.SqlServerCe.3.5;provider connection string=&quot;Data Source=|DataDirectory|\LocalData.sdf&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SqlServerCe.3.5"></remove>
      <add name="Microsoft SQL Server Compact Data Provider"
           invariant="System.Data.SqlServerCe.3.5"
           description=".NET Framework Data Provider for Microsoft SQL Server Compact"
           type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
    </DbProviderFactories>
  </system.data>

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
        <bindingRedirect oldVersion="3.5.1.0-3.5.1.50" newVersion="3.5.1.50"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>

</configuration>

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 Code Project Open License (CPOL)


Written By
Software Developer (Senior) Foresight Systems
United States United States
David Veeneman is a financial planner and software developer. He is the author of "The Fortune in Your Future" (McGraw-Hill 1998). His company, Foresight Systems, develops planning and financial software.

Comments and Discussions