Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Visual Studio Professional 2010, database

Posted on 2010-08-13
2
Medium Priority
?
503 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 500 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 500 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

885 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