How can I connect to SQL Server CE using web.config

Question

I would like to know how can I connect to a SQL Server Compact Edition database from my web application?

Usually I insert the connection string in the code. How can I connect to the database which is situated in App_Data in the web.config file?

Thanks in advance

http://www.connectionstrings.com/sql-server-compact/ – marc_s Mar 24 '15 at 11:18 — marc_s, Mar 24 '15 at 11:18

score 0 · Answer 1 · answered Mar 24 '15 at 11:15

0

In your web.config have a connectionString like

<connectionStrings>
<add name="MyConnection" connectionString="Data Source=|YourDirectory|\DBName.sdf"/>
</connectionStrings>

1 Answers1