Questions for MySQL evaluation

[Vikas]

I'm thinking of embedding MySQL in a .NET application. The
application will run on a Windows PC and also on a PocketPC handheld;
it's to be a single-user application, holding up to a dozen tables
with a few hundred records in each table.

If I understand correctly, embedded MySQL doesn't support
replication/sychronization (please correct me if I'm wrong). If this
is the case, are there any other solutions for synchronizing data
between the PC and the handheld? Any third-party components or
libraries that one could embed into the application as well to handle
synchronization? Or, alternatively, are there some available examples
of code that does this? I'm very reluctant to attempt to do this
myself, for obvious reasons of complexity.

And, also, has anyone used an Object-Relational mapping tool or
framework with MySQL that they can recommend? Ideally, this would be
a solution that would run within the application on the handheld as
well, or would generate classes usable on the handheld.

Thanks for your help.

Vikas

[Chris Hope]

Vikas wrote:

I'm thinking of embedding MySQL in a .NET application. The
application will run on a Windows PC and also on a PocketPC handheld;
it's to be a single-user application, holding up to a dozen tables
with a few hundred records in each table.

If I understand correctly, embedded MySQL doesn't support
replication/sychronization (please correct me if I'm wrong). If this
is the case, are there any other solutions for synchronizing data
between the PC and the handheld? Any third-party components or
libraries that one could embed into the application as well to handle
synchronization? Or, alternatively, are there some available examples
of code that does this? I'm very reluctant to attempt to do this
myself, for obvious reasons of complexity.

And, also, has anyone used an Object-Relational mapping tool or
framework with MySQL that they can recommend? Ideally, this would be
a solution that would run within the application on the handheld as
well, or would generate classes usable on the handheld.

This doesn't answer any of your questions, but I suspect if you are planning
to embed MySQL in a .NET application and sell it on to 3rd parties without
releasing the source code you'll need to purchase a MySQL commercial
license

http://www.mysql.com/company/legal/l...l-license.html

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Vikas]

Chris,

Thanks. I'm aware of the licensing issues. At least at first, the
developed applications will be for personal, non-commercial use.

Vikas