Solved

Visual Studio Professional 2010, database

Posted on 2010-08-13
2
474 Views
Last Modified: 2013-12-17
I am starting a new project, I will be using Visual Studio Professional 2010, .Net Framework 3.5 and Programming Language C#.  The project requires a database, which will be simple, containing 4 or 5 tables.

The main function of the program will be to learn a foreign language for my school. So the database's main function will be to listen to sample recording in the foreign language. I will start up as a standalone desk top application but plan to migrate to a server environment in the future.

I am considering using MySQL as the database but I see where Visual Studio Professional 2010 comes with what looks like an internal database. My question are:

1: Which database would you recommend I use?
2: Advantages/Disadvantages of both?

Thanks

0
Comment
Question by:crp81
2 Comments
 
LVL 19

Accepted Solution

by:
Amandeep Singh Bhullar earned 125 total points
ID: 33435647
MySQL is a good option.
But you can use SQL express edition 2010. Its free and MS product.
This will give you a better performance with .net
0
 
LVL 18

Assisted Solution

by:Anil Golamari
Anil Golamari earned 125 total points
ID: 33436515
I think MS SQL Server will be a good option with .net application, as you have may feature in .Net framework which supports Sql Server. For example you use LINQ to SQL to connect to database and also do dml operation on the data instead of using SQL queries.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now