Solved

Visual Studio Professional 2010, database

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 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

12 Experts available now in Live!

Get 1:1 Help Now