Access SQL Database from ASP.net

[Ido]

I want to consult with you about SQL versions to access from ASP.net?

1) I just want to be sure: I read in one of many decent book about
ASP.net that says: "you need to install SQL 7.0 or higer to develope
ASP.net database applications" ... well I guess the author knows
better than me, but I got different answers, such as "you can use any
Database that suuport ODBC (include SQL6.5) for example.
Im a little confuse here ??

2) I downloded from microdoft site this version of SQL Server compatible:
"msde.msi" and it is a free SQL Server compatible database engine
(database administration from within the ASP.NET Web Matrix
development ) MSDE does not have its own user interface (UI) or
tools. You interact with MSDE through the ASP.NET Web Matrix
development environment. I tried this a little and I was able to make
tabled easily thru ASP.NET Web Matrix development environment

Question: if you are fimiliar with this product, can you tell how much I
can rely on it? can I fill it with such amount of data as I would in
SQL7.0?(for example) what are the differents between SQL and this
SQL Server compatible product?

Thanks,

 

[Derek Stone]

System.Data.SqlClient supports SQL Server 7.0 and higher. However you can still access all version of SQL Server through the System.Data.OleDb namespace. SqlClient simply provides a faster and more efficient means of access.

MSDE is a slightly limited version of SQL Server, since it only allows for databases up to 2GB in size. Its also optimized for use by 2 - 4 users, although you wont notice a difference with a much higher load.

 

[Ido]

Many thanks