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

 

May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Archives

  • May 2012 (55)
  • April 2012 (81)
  • March 2012 (82)
  • February 2012 (79)
  • 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

  • Flash, HTML5 or Silverlight?
  • Data Binding Part 1
  • Silverlight Data Visualization
  • Database connection string access 2003 and 2007
  • coresuite map EN

Tags

.NET 2010 about AJAX Application Applications ASP.NET best Business cheap cloud Company Computing Control Create data Dedicated Development Free from help Host hosting India 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