Solved

Visual Studio Professional 2010, database

Posted on 2010-08-13
2
482 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.   …
The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

821 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