Embedded MSSQL Express ?

Question

Hello

Somebody said me that MSSQL 2008 Database work other computers without installing MSSQL2008 if i do checked prerequites while i setup MSSQL 2008. is it true ? if it is true, should i resetup MSSQL2008? or what should i do ? I also need MSSQL2008 database work with installing MSSQL2008 for other computers.

if it is false, i setupped SQL Compact 4.0. But what should i prefer database type to use ADO.NET ?

SQL compact use same SQL query with MSSQL ?

Answer 1

Hello,

To use SQL Server databases you need an installed SQL Server, there is no way around.

SQL Server Compact Engine (CE) is an in-process engine, which supports a subset of the feature of the SQL Server. Ado.Net contains provider for SQL Server as well as for SQL Server CE.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Thank you for reply.

There are two type of database as SQL Compact databases. Which one i should use with ADO ?

For example

SqlCeConnection object in System.Data.SqlServerCe.dll.

Answer 3

What for "two types" do you mean?

Or do you mean the version 3.5 and the new one 4.0? If so, use the new one.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

I use 4.0 version of sql compact.

When i add new item of my project at visual studio, i select local database of data. I see dataset and entity data model at there. Which one should i use ?

Answer 5

That depends of what you want to use, a typed DataSet or Entity Framework; but this all is independent of SQL Server / CE, that's more a .NET Framework related question.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing