Database choice to use in C#

  • Thread starter Thread starter Mads Westen
  • Start date Start date
M

Mads Westen

Hi,
I'm in the design phase of a little database program in C#.
But I don't know what database to use.
The DB should be free, easy to set up, and easy to program up against in C#.
I'm using VisualStudio.NET 2003, wich I have a Certified Partner licence
for.
I have never used ADO before, and I'm somewhat of a newbie in C# also. :)

What DB is recommendable?
Are there any good guides regarding this subject?


Best regards

Mads
 
It really depends on your needs.

Overall, I prefer SQL Server for enterprise needs. If that is more power
than you need, you can download the free MSDE (MicroSoft Database Engine),
which is essentially SQL Server lite. Access is also popular with many
people, but it requires you have a copy of Access (not really, but it is more
of a pain to work without the tool). For free databases, MySQL is quite
popular and you can find many ISPs that support it.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
1) I would download and use SQL Server Express edition. It's free and fully
SS 2005 compatible (because it's SQL Server binaries).
2) MSDE is more trouble to use. It's dated by now and the Express edition
solves many of its issues.
3) JET/Access does NOT require you to buy anything or have Access installed
but I cannot recommend it for business use.

Most ISPs support one form of SQL Server or another. Most will not support
JET.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Hi guys,

Thanks for your answers.
I've decided to use MS SQL 2005 Express edition. But I've been told to wait
for Visual Studio 2005 to be released. The problem is just, that I don't
have 2 months to wait for VS 05.
Could I use VS 03 with SS 2005?

Where can I find good tutorials on how to begin with SS 05 in C#?

Best regards
Mads
 
Mad,

I told you in another newsgroup to ask here advice because I had seen many
messages that told that firebird is a good alternative (from more
directions). However, I don't know it. I don't see the advices in this
message thread to you either.

I don't know anything of it.

http://firebird.sourceforge.net/

I hope this helps,

Cor
 
Bill,

Where did you find that the final release of SQLexpress is free.

See this page at "general" and in the bottom of the SQL Server 2005 express
Edition where for me obvious is spoken about the april CTP version.

http://lab.msdn.microsoft.com/express/faq/

In my opinion is it at least confusing.

Cor
 
I've been looking at SQL 2005, and can see that releasing a program based on
that this year, can be a problem.
So I took a look at the firebird (thanks for the link Cor), which has a ADO
to .NET.
So maybe my choice will fall on that one.

With my program not beeing that complex, and given that I have an ADO to
both DB's, the difference between choosing MS og Firebird isn't that big of
an issue for my final code is it?

Now all I'm searching for is a good guide to get startet with building DB
driven applications in C#.

Best regards
Mads
 
Just a warning, SQL Express is not something that can exactly be labeled as
easy to set up. There is an install program, and all sorts of various setup
and IT issues. It requires that someone keep up with security updates etc,
and knows how to administer it.

Where as something like Jet, you really don't have to worry about any of
that. It is also easy to distribute the database, since it is just an mdb.

Not saying you shouldn't use SQL Express, but just saying that there are
other things to consider, especially depending on your target audience.
 
When do you expect to go into production? The RC1 version of SQL Server is
now freely downloadable and can be used until RTM (due in mid October--less
than three weeks away). Yes, Cor, it's still free. Yes, I expect you'll have
to buy Visual Studio 2005 to get it though. Yes, it's a bit harder to
administrate than JET but it's far safer and more secure. It's designed
specifically for your situation.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top