which database is best with .net

Discussion in 'MySQL' started by gramyla, Mar 2, 2009.

0
  1. #1
    tell me which database is best while working with asp.net i have many options like
    sql server
    msacess
    oracle
     
    gramyla, Mar 2, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    It depends on your needs. But at least don't go for MS Access unless your application is a single user application.
     
    mwasif, Mar 2, 2009 IP
  3. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #3
    SQL Server
     
    plog, Mar 2, 2009 IP
  4. sampathsl

    sampathsl Guest

    Messages:
    861
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Its obviously SQL Server. It performs better than any other DBMS with ASP.NET. :)
     
    sampathsl, Mar 2, 2009 IP
  5. qazu

    qazu Well-Known Member

    Messages:
    1,834
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    165
    #5
    Definitely SQL Server
     
    qazu, Mar 2, 2009 IP
  6. Markster91

    Markster91 Peon

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    SQL Server lol
     
    Markster91, Mar 3, 2009 IP
  7. peterCx

    peterCx Peon

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Ms sql because it's microsoft's
     
    peterCx, Mar 9, 2009 IP
  8. decodethis

    decodethis Well-Known Member

    Messages:
    436
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    #8
    SQL Server Express (2005 or 2008) is a great choice and typically free on most hosts. You can create a database up to 4GB in size and it allows stored procedures and uses the same file format as SQL Server. All in all an excellent choice for a .NET based site.
     
    decodethis, Mar 10, 2009 IP
  9. bhandari

    bhandari Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    sql is best data bade in asp .net
     
    bhandari, Mar 10, 2009 IP
  10. CodeWorld

    CodeWorld Peon

    Messages:
    420
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #10
    MS SQL cause its from Microsoft. So, there will less synching problems between SQL and ASP.NET and there is tons of trouble shooting material available. Believe me, we are using ASP.NET with Oracle for some reasons and its certainly not a good ride.
     
    CodeWorld, Mar 10, 2009 IP
  11. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #11
    ASP.Net and SQL server are good combination (like PHP and MySQL).

    Kailash
     
    kailash, Apr 4, 2009 IP
  12. MayurGondaliya

    MayurGondaliya Well-Known Member

    Messages:
    1,233
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    170
    #12
    Yes, PHP-MYSQL and .NET-MSSQL are good combinations.

    However, MySQL has provided the managed component (mysql.data.dll) to deal with MYSQL server on .NET very efficiently.
     
    MayurGondaliya, Apr 9, 2009 IP
  13. 2beers

    2beers Well-Known Member

    Messages:
    195
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    110
    #13
    well it depends you can use ms access if only one users need to connect to teh database.
    if you want multiple users to connect to the database sql server. however if you don't want to spend money on sql server you can use mysql. i've made 2 years ago in .net an application which is conecting to mysql and worked fine.
     
    2beers, Apr 17, 2009 IP