Programmatically create SQL Server CE 4.0 Database and add a schema in C#?

Question

I'm having a go at learning to use SQL Server CE databases as a storage medium for my applications. I've currently been storing data in text and xml files, but thought I should move onto something more appropriate for my project as the text files are getting abit messy.

I have now learnt how to programmatically create an SQL Server CE 4.0 database file in C#, but is there any way to programmatically add an already built Schema to that newly created database file in C#?

That question is not a duplicate, this one asks for schema and doesn't even reference dynamic creation of the final file. (Re-added comment for others) — Guvante
– Guvante, Commented Feb 23, 2013 at 19:35

horgh · Accepted Answer · 2012-08-28 01:41:49Z

1

I guess, it depends on what approach you use to work with a database. If Linq to Sql is available (say, you're not using .Net Compact Framework), you can create database by the following code:

using (MyDataContext dc = new MyDataContext("Data Source=\"test.sdf\""))
{
    dc.CreateDatabase();
}

instead of

SqlCeEngine en = new SqlCeEngine("Data Source=\"test.sdf\"");
en.CreateDatabase();

Linq DataContext creates db schema automatically.

answered Aug 28, 2012 at 1:41

horgh

18.6k22 gold badges70 silver badges125 bronze badges

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

Collectives™ on Stack Overflow

Programmatically create SQL Server CE 4.0 Database and add a schema in C#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related