which database is better for .NET? Oracle or SQL Server? Please explain in details.?

Question

which database is better for .NET? Oracle or SQL Server? Please explain in details.?

Answer 1

personally i would say SQL Server, as if your using two products from the same vendor, you should get better results. also if your using web developer it gives you the chance to really use some of sql server to your main advangate as there is a really good gui for interfacing with sql server.



as far as i know there you need to download the oracle data provider to use oracle well with .net, orcaled called theres ODP, this owuld be the same if you used another database that isnt microsoft.



SQL Server already has n sql server libary built in. i havnt used a lot of oracle, but most of the people who i knwo do have said the sql server is easier to configure and use. im going though using orcacle at the moment so ill let u know at a later stage which i prefer.



oracle is a EXPENSIVE, SQL server is a little cheaper. if you want a free database you could look at mysql.



. Net is a programming framework, used for developing window forms/ and web applications

Answer 2

I would suggest SQL Server. From my personal experience not only is SQL Server Cheaper than Oracle but it also puts less load on your system. Oracle also has a problem of creating problems and incase you are not an expert you might even have to reinstall it all over again, in which case you would have to remove the registry entries manually at times to be able to make a fresh installation. SQL server is much easier to use. For a free version u can go for MySQL. N yes for a reference SQL Server is the preffered database for .Net, as u'll see it gives support for accessing the functions, tables, procedures directly from inside the developer to make the changes. U needn't open SQL Server again n again.

Answer 3

ORACLE is the better database if you are talking a large datawarehouse type of application. If you are looking for lots of users hitting at the same time then you could cluster SQL Server and get a lower cost per user. If you are just wanting to learn .net and need a server to work with then I would go back to Oracle. They allow you to download a free copy of the database for development purposes.

Answer 4

Oracle: Best but expensive

SQL Sever: Mature and economical

.NET: Not a database, it's an environment to execute .net aware applications (database related and others).

Answer 5

in short, programming is the style you make certain the undertaking and programming language is the style you tell the gadget to attain this. of path, this answer is basically at rather worry-loose thought element. in case you have not have been given any further something to do with desktops yet basically want to recognize the version above then my answer is sufficient for you, in any different case in case you want to alter top right into a programmer, then particularly of asking one among those question that do you now not something like above, make certain on a language, learn it and attempt to unravel the undertaking by using ability of what you have found out. learn programming in a distinctive programming language in case you do want to create subject concerns. as quickly as you would be able to desire to utility good in that language, learn yet yet another and learn those 2. in the journey that your the thank you to utility with out any specific language (attending to charm to close programming in pseudo code basically) and you will have not have been given any further something to do extra effective valuable than to throw you artwork into the thrash basket. attempt to do the easy first, make a real element first, and the complicated after.

Answer 6

Depends on the amount of data you have and the rate you are receiving them. I have applied complex algorithms and queries in MS Access on a few million records, and it works fine.