Click here to Skip to main content
12,998,483 members (128,885 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I have a c# application written around MySQL database which i want to deploy. Please how do i go about this because i can't seem to know how to attach the database file.
Posted 8-Jan-13 7:51am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Your user will need MySql installed, I do believe. SQLlite is the non MS DB that deploys via a dll.
Emejulu JVT 8-Jan-13 14:48pm
I don't want the user to know that there is a database packaged let alone the type of database. If SQLite would do same job for me while deployed using ClickOnce Application deployment, then i'll be happy to know were to download it and how to use it please. Thanks a lot
Christian Graus 8-Jan-13 14:49pm
You can find SQLite with google. Yes, both it and SQL Server Compact Edition ship as a dll, not an install. Choose one, the main difference is that SQL Server Compact won't accept more than one user at a time.
Emejulu JVT 8-Jan-13 15:18pm
Thanks a lot, you've given me some hope. So hope do i integrate it into visual studio 2008.
Christian Graus 8-Jan-13 15:21pm
You just make a reference to the dll in your project, and it will be in your output directory
supernorb 5-Apr-13 8:46am
SQLite is something new and cool except that I can't even add Relationships with constraint rules like 'On delete cascade' and 'On udpate cascade', After creating the relationships, it can't help us to not make any conflict whereas a Foreign key constraint should do help.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170622.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100