Checklist when deploying SQLite with .NET application

Question

I need to deploy SQLite file with WPF application.

Deployment technique is ClickOnce.
Entity Framework is included to work with the database.

I'd like to have a shortlist what must be considered when deploying the application that includes a SQLite database file in it.

So far, I have referenced and set Copy Local to True for:

System.Data.SQLite
System.Data.SQLite.Linq

.and I have two interops where Copy to Output Directory I left to be the default Copy Always

SQLite.Interop.dll (x86)
SQLite.Interop.dll (x64)

In the app.config file I have:

<applicationSettings>
    <MyApp.MySettings>
       <setting name="connStrSQLite" serializeAs="String">
           <value>data source="C:\MyFolder\MySQLiteFile.sqlite3"</value>
       </setting>
    </MyApp.MySettings>
</applicationSettings>

and

<connectionStrings>
    <add name="MyEntities" connectionString="metadata=res://*/Model.ORM.MyModel.csdl|res://*/Model.ORM.MyModel.ssdl|res://*/Model.ORM.MyModel.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;C:\MyFolder\MySQLiteFile.sqlite3&quot;'" providerName="System.Data.EntityClient" />
</connectionStrings>

I suppose in the app.config the paths are not working on deployed application since they are referring to my local folder now. How to modify them?

Then, I checked for example from here SQLite deployment for .net application that the following should be added to app.config file.

<system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>
</system.data>

Anything else?

So how to automatically include those interops? The only answer doesn't seem to address the Q though is accepted. @Dimi This is not a duplicate as it deals with other deployment method. — mlt
– mlt, Commented Aug 31, 2016 at 1:51

avs099 · Accepted Answer · 2013-09-05 12:19:18Z

2

regarding your connection string - for ClickOnce installation you should use |DataDirectory| substitution instead of full path - runtime will automatically convert this into proper local path:

<connectionStrings>
    <add name="MyContext" connectionString="DataSource=|DataDirectory|Mydb.sdf" providerName="System.Data.SqlServerCe.4.0"/>
  </connectionStrings>

answered Sep 5, 2013 at 12:19

avs099

11.2k6 gold badges66 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Checklist when deploying SQLite with .NET application

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related