Tuesday, February 14, 2012

Compatibility of MSDE with .NEt

Hai frnds,

Can i use MSDE for my .net applications instead of SQl server ?

Yes.|||

Can u sugget some good documents regarding MSDE compatibility with .NET

Applications

|||

There's nothing much to say. MSDE is basically the same thing as SQL Server execept some performance limitations and missing components (no graphical interface tools, no analysis services etc). Other than that it supports exactly the same SQL syntax and data types, views, triggers etc like SQL Server 2000 and for connection you use the same classes (System.Data.SqlClient) and connection strings.

You may also want to check SQL Server 2005 Express Edition which is also free and works with .NET and replaces MSDE. See http://www.microsoft.com/sql/editions/express/default.mspx

http://www.microsoft.com/sql/editions/express/upgrade.mspx

http://www.microsoft.com/sql/editions/express/features.mspx

No comments:

Post a Comment