How do I embed an SQL Server Express database with a C# application?

I haven't been able to find any decent tutorials for easily deploying a C# application with a bundled SQL server 2005 express database. Does anyone have any good information regarding this?

[196 byte] By [1nsane] at [2007-12-21]

«« delay displaying .net forms
»» Power icon problemw

# 1

Using SQL express database is really simple, if you are already used SQL Server. There is only difference in connection string where instead of Setting Data Initial Catalog, you should set AttachDbFilename with file path to your database mdf file. Data Source attribute has to be changed and in case of default installation of SQL Express that is
.\SQLEXPRESS
One thing about connection is important and that is, authentication must be Windows, SQL is disabled by MS.
If your create setup, in VS 2005 you can add prerequsities in setup project properties, from where you can select many important packages like, .NET Framework 2.0, Windows Installer 3.1, and of course SQL Express.

boban.s at 2007-9-10 >

top of Msdn Tech,Visual C#,Visual C# General...

# 2

Look at this article, it's for MSDE but works with SQL Express too.

StefanProdan at 2007-9-10 >

Visual C# Hot Topic

Visual C# New Topic

Visual C#

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech