标签：SQL Server Compact Edition
VS 2010 SP1 and SQL CE

 Last month we released the Beta of VS 2010 Service Pack 1 (SP1). You can learn more about the VS 2010 SP1 Beta from Jason Zander’s twoblog posts about it, and from Scott Hanselman’s blog post that covers some of the new capabilities enabled with it. You can download and install the VS 2010 SP1 Beta here.

Last week I blogged about the new Visual Studio support for IIS Express that we are adding with VS 2010 SP1. In today’s post I’m going to talk about the new VS 2010 SP1 tooling support for SQL CE, and walkthrough some of the cool scenarios it enables.

本日志由 flyinweb 于 2012-01-04 11:24:14 发表到 数据库技术 中，目前已经被浏览 505 次，评论 0 次；

作者添加了以下标签： VS 2010 SP1，SQL CE，SQL Server Compact Edition；

首页只显示了部分日志内容，要查看日志的全部内容请阅读全文；

Creating your SQL Server Compact Edition database and schema in code

In most cases you'll want to create your database and it's schema as part of your applications first deployment. Depending on the scenario, you may create it on the client, or create it on the server, do the initial sync, then stream the file down to the client pre-populated.

Why would you create the database on the fly, rather than ship the initial database with your app?

While you could create the empty shell, and deploy it, you'll almost never want to start with a database that has data? Why? While in development, you'll have some set of data. Months later, when another user first installs your app that data may no longer be valid. Since most sync systems don't track deletes forever, you could wind up with data that is very stale, and now way to effectively update it.

本日志由 flyinweb 于 2012-01-04 11:01:27 发表到 DotNet专栏 中，目前已经被浏览 387 次，评论 0 次；

作者添加了以下标签： SQL Server Compact Edition；

首页只显示了部分日志内容，要查看日志的全部内容请阅读全文；

Connection strings for SQL Server Compact Edition

.NET Compact Framework Data Provider for SQL Server Mobile

Type.NET Framework Class Library
UsageSystem.Data.SqlServerCe.SqlCeConnection
ManufacturerMicrosoft
Set example values »

More about this class library »

Standard

Data Source=MyData.sdf;Persist Security Info=False;

How to specify the location of the SDF file

Often times the .SDF database is not running in the current directory so it becomes necessary to programatically set the path to the SDF file. This is an example (.net C#) on how to do this when the SDF file is located in the same directory as the executing application.

本日志由 flyinweb 于 2012-01-04 10:55:51 发表到 数据库技术 中，目前已经被浏览 368 次，评论 0 次；

作者添加了以下标签： SQL Server Compact Edition，Connection strings；

首页只显示了部分日志内容，要查看日志的全部内容请阅读全文；