Click here to Skip to main content
11,719,816 members (89,571 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# MySQL
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
good
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.
  Permalink  
Comments
Emejulu JVT at 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 at 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 at 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 at 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 at 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
0 Sergey Alexandrovich Kryukov 665
1 OriginalGriff 340
2 F-ES Sitecore 185
3 Suvendu Shekhar Giri 140
4 Maciej Los 100
0 Sergey Alexandrovich Kryukov 1,734
1 OriginalGriff 690
2 Maciej Los 569
3 Richard MacCutchan 540
4 F-ES Sitecore 510


Advertise | Privacy | Mobile
Web03 | 2.8.150901.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2015
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