Hi, I just want to know what is the recommended database system if I would want to develop a system with ASP.Net?

Microsoft Access? Microsoft SQL Server 7.0? or...??? And what is ADO.Net actually? How does it relates to database? Or it is just a kind of connection method to database?

What about ODBC? I really confuse with all these stuff.

As the data base is concern it depends on your system if system is small then MS Acces else SQL Server and ADO and ODBC are the objects to connect to the database




Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

if you want to use ASP.NET,ADO.NET .its better to use MS SqlServer its faster because there isnt any provider between ADO connection object and MS SqlServer(7 or above).

--------------------------------------------
Mehdi.:)

Thanks ya qazi for the valuable suggestions. If the ADO and ODBC are the connection object to the database, does it means that no matter I use MS SQLServer or MS Access, I can choose either connection object, either ADO or ODBC?

But... mehdi, I can't get you... Do you mean that if I would want to use ASP.net and ADO.net, then I have to use MS SQLServer because ADO connection is not supported in MS SQLServer version 7.0 and above?


chuah

First, I would NEVER use access for a web site with any kind of volume. It's not built for it.

Second, I wish people would forget ODBC exists- It's slow and outdated. Using ADO.NET and the proper connectors your performance and reliability will go way up- and you don't have to worry about setting up ODBC connections on the servers.

Third, ADO.NET works with SQL Server as well as Access and many other "databases". Microsoft developed optimized methods that can be used with SQL Server 7.0 or Greater (I'd not even consider 7.0 at this point.. and use 2000.. or if your relase date is sometime off, 2005). Your optimal performance with ADO.NET is going to be with SQL Server 2000 at this point.

What you should use is going to depend on your requirements. There is no one size fits all answer.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

chuah,
first you should select your DataBase Management(like MS SQLserver,Access,Oracle,MySQl)
then according to above you should select your DataProvider(DataProvider is an object that connects your Connection object(like SqlConnection,OleDbConnection)to your DataBase Management software)i.e for MS Access you need OLED Provider and for MS SQLServer (7 or above)you dont need any DataProvider at all so using MS SqlServer could result more performances
sorry if I couldnt represent my meaning...
Hope it was clear.
(if u need more explanations no problem)

--------------------------------------------
Mehdi.:)

Mehdi, Why would you say you don't need a data provider for SQL Server? There is a data provider, just when you use the SQL Server namespace, it's assumed....

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I ment There is no additional DataProvider Layer & no need for Translation to TDS.


--------------------------------------------
Mehdi.:)

Ya, you all are really helpful.

Listen to Hal's advice, now I would forget about ODBC, because I have to narrow down my choices as well, otherwise I will be lost in middle of somewhere, rite? And I just bought Wrox's ADO.net bible, so I would not prefer ODBC as well. ;)

From yours' reply, ODBC and ADO.net are an object which connect to our DBMS, rite? Then, now I understand also that ADO.net has its support in MS Access as well as SQL Server.

And.... now, mehdi... follow what you have adviced me, the first step is that to choose a DBMS. But, before I choose a DBMS, I am very confuse also what are the DBMS out there that are avalaible. From what I know are MS Access, Oracle, and SQL Server 7.0. The worst is that I always confuse with "MS SQL server", "SQL Server 7.0", "MySQL", "SQL Server"... Does all these "name" refer to same DBMS or there are definitely different DBMS? May you just list out the DBMS item by item especially for those DBMS which quoted "SQL" as above.

I know after the selecting of DBMS, I have to choose a Data Provider so to connect to DBMS, rite? This one I would assume the use of ADO.net as suggested by Hal. However, I would like to solve the first step problem first, as I still confuse what are those DBMS yet.

Hal, I am very agree with what you said,

 

I will draft out the system that I will going to develop later, so to get your advice further.


Chuah

no,they are different i.e
1-MS Access
2-MS SqlServer(or SQLServer)
3-MySQL
4-Oracle
.....
all of them use SQL language(like SELECT * FROM .....)
for everyone you should use different provider that means u should use different namespace i.e
MS SQLSERVER(7 or above)------------->System.Data.SqlClient namespace
MS Access(or MS SQLSERVER below 7)----------------->System.Data.OleDb namespace
MySQl----------------->u should find the suitable provider from microsoft.com(its not installed with .NET defaultly)
Oracle--------------------->like MySql
HTH.

--------------------------------------------
Mehdi.:)