Geek Answers Handbook

How to use SQL Server CE in an ASP.NET application

I want to create a new application using SQL Server CE in asp.net, but I don’t know how it starts up properly, please help me how can I use this.

Please help me....

+4
source share
2 answers

Read Scott Guthrie's wonderful blog post on the subject:

New support for embedded databases with ASP.NET

He talks about how to use the new version of SQL Server Compact v4, specifically designed for use with ASP.NET applications.

+3
source

Since CE is a built-in file-based database, it’s not worth it to start - you just specify the file in the connection string ( see MSDN ).

EDIT: CE is not supported in web applications prior to CE 4

However, make sure it is easy to deploy, but CE may not be the best option for a high-threaded environment such as a web server (in fact, it is configured for clients, although server use is supported). See Here TSQL Differences , Transaction Differences , etc.

+2
source

More articles:


All Articles