embedded MySQL for .NET

  • Thread starter Thread starter ZG
  • Start date Start date
Z

ZG

Is it possible to use embedded MySQL as a behind-the-
scenes database for a desktop application written in C#
or VB.NET. It doesn't have to be MySQL, i was just
wondering if there's any type of database i could use
where the user wouldn't have to install database software
or a service. And i'd like to use standard SQL
statements.

The documentation of embedded mysql wasn't very detailed,
maybe if someone could point me in the right direction?

Thanks,
Zack
 
You can use MySQL with .NET.
The only thing is, that no matter what database you want to use, you will
have to install it.
MySQL also requires installation, the most important part to you as a
developer being the install of a good MySQL ODBC driver. Then you have some
endless config to do because bare-bones MySQL isn't very admin-friendly :-)
If you install the MDAC redistributable, you can use Jet to create MS Access
databases fairly easily.
It also has an ISAM layer, so you can deal with databases like dBase.

-Rob Teixeira [MVP]
 
MSDE is the free microsoft sql server engine. It's basically SQL Server with a max 25 user limit and i think 2 gig limit on tables. It is possible to distribute that as part of the installation with your application, there is good documentation on it at the MSDE site. I believe setting up databases and users and all that fun stuff is done through some API's, but you might be able to figure out how to just run some SQL script to automate it all for you.

I thought MySQL had some API's also to auotmate the setup. The only problem is you need to fire off the setup program for MySQL prior to running the API's kind of a catch 22. It is possible though with a decent install program. The nice thing about MySQL though is once you install it, you can just copy the table directory from your development to the distribution directory and you're ready to go. A good install program will have no problems with scripting that.


**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
Back
Top