Skip to posts
  • About

Win Web Hosting

Web Hosting Information
  • Home
  • ASP.NET
  • Cloud Hosting
  • Dedicated Servers
  • Linux Web Hosting
  • Microsoft AJAX
  • Microsoft Siverlight
  • Windows Web Hosting

What database technology to use with asp.net using c# and why? I’m doing some research for a project I have?

April 24, 2010 James 2 comments
ASP.NET ASP.NET, database, doing, Project, Research, some, Technology, Using

Comments

Leave a comment Trackback
  • Written by Beldemhein about 2 years ago.

    If you use a DAL generation technology like SubSonic or use linq in your code it shouldn’t matter what your DB is.

    MS Access is free but it sucks no serious developer should ever use this.

    MySQL is free and maybe lacking in a few features but it is a valid alternative if you don’t want to shell out cash for SQL Server.

    Oracle is a huge pain in the butt. Don’t use it with .Net technologies unless absolutely necessary. It is like hitting a railway spike with a train that needs 30 people to make sure it stays on the tracks. Or like some other crazy analogy. You can’t do simple things like declare a boolean column or set a primary key column as identity. You have to do everything manually and you have to endlessly muck around with triggers. After the initial set up costs it gets cheaper to use but the initial set up costs are pretty big. Also the documentation is sparse and the error codes are as cryptic as they come.

    M$ SQL Server is quite simply amazing. Don’t take it for granted. Flexible, scalable and easy to use. Books online is your best friend.

  • Written by lolvark about 2 years ago.

    SQL Server 2005/2008, or the express version if your database is small are good choices with asp.net and c#. If you use VS2008 or visual web developer, you drop a sql connection and a control and the code is generated. the code is even pretty efficient. the ado .net framework has a very powerful sqlclient api.

    access is a single use database. people tried often but sooner or later something will go wrong with locks.

    i agree with the other person’t assessment about oracle: very costly, not at all well integrated with the .net framework, and lots of sql server features missing. (i used oracle for 5 yrs).

    mysql may work but it is not a high performance transaction oriented database. it deoends. if you store text and pics, maybe mysql will work

Comment Pages:

Leave a Comment

Cancel Reply

You must be logged in to post a comment.

RSS

Win Web Hosting Home Page

Cheap Windows Hosting

 

February 2012
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
272829  

Archives

  • February 2012 (24)
  • January 2012 (92)
  • December 2011 (163)
  • November 2011 (205)
  • October 2011 (339)
  • September 2011 (367)
  • August 2011 (367)
  • July 2011 (322)
  • June 2011 (338)
  • May 2011 (358)
  • April 2011 (94)
  • March 2011 (40)
  • February 2011 (36)
  • January 2011 (41)
  • December 2010 (30)
  • November 2010 (40)
  • October 2010 (41)
  • September 2010 (52)
  • August 2010 (150)
  • July 2010 (165)
  • June 2010 (159)
  • May 2010 (238)
  • April 2010 (248)
  • March 2010 (202)
  • February 2010 (576)

Recent Posts

  • Video scrubbing control with Silverlight – Tips and Tricks
  • ASP.NET Styles More…
  • MIXMASH (Featuring WPF & its little brother Silverlight)
  • ASP.NET TreeList – How to Delete Selected Nodes
  • [howto] animations in silverlight 2.0 with Expression Blend

Tags

.NET 2010 about AJAX Application ASP.NET best Business cheap cloud Company Computing Control Create data Dedicated Development Free from help Host hosting India Internet Introduction Linux Microsoft more need Page Part private Server servers service Services Silverlight Site Software Source Tutorial Using Video website Windows

Categories

  • ASP.NET
  • Cloud Hosting
  • Dedicated Servers
  • Linux Web Hosting
  • Microsoft AJAX
  • Microsoft Siverlight
  • Windows Web Hosting

Meta

  • Register
  • Log in
  • Valid XHTML
Powered by WordPress Web Design by SRS Solutions © 2012 Win Web Hosting