Saturday, March 31, 2012 10:41 AM
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 ?
Saturday, March 31, 2012 12:20 PM
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.
Saturday, March 31, 2012 12:24 PM
Thank you for reply.
There are two type of database as SQL Compact databases. Which one i should use with ADO ?
SqlCeConnection object in System.Data.SqlServerCe.dll.
Saturday, March 31, 2012 12:36 PM
Saturday, March 31, 2012 12:56 PM
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 ?
Saturday, March 31, 2012 1:15 PMThat 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.
- Marked As Answer by JuniorCsharp Saturday, March 31, 2012 2:37 PM