Which Database is Good for Asp.Net? [closed]

Question

I have been using oracle database throughout database courses, and I have programmed there a lot. However, now, I have to develop real life web application in ASP.NET and some people suggested me to use sQL server because it is more compatible with ASP.NET.

But I did not like it at all using it, since, I got used to oracle programming, and SQL server MAnagement studio works a real slow in my computer, not like oracle.

So, what do you guys suggest me to do, does ASP.NET support it real badly? I may use linq-to-sql and Nhibernate I am not sure. Which databases will not create much problems when using them?

Answer 1

There are definitely some benefits to using SQL with ASP.NET, since the two are architecturally synchronized. However, plenty of high-performing applications use Oracle. NHibernate works fine with Oracle. The productivity gains from sticking with what you know will probably outweigh any sugar for SQL that .NET has baked-in.

Answer 2

LINQ to SQL doesn't work against Oracle at all as far as I'm aware. NHibernate does, and I believe the Entity Framework does (it certainly should - working with multiple databases is one of the selling points of EF over LINQ to SQL; try it before making a firm decision though!)

I've known a few quirks in the Oracle .NET drivers before now, but they generally work okay. If you don't mind losing the option of LINQ to SQL, and you're significantly more comfortable and productive with Oracle, then I'd stick with it.