Automatically Connecting Sql Databases to C# Application?

Question

1.00/5 (1 vote)

See more:

, +

Hey there

I was wondering if anyone could provide me with information about SQL databases and C# Applications. Basically I'm working on a project in which I would like to be able to Create, Import, Export and Delete SQL Databases using a C# Application automatically. By this I mean that instead of having to provide a location in the program, e.g. A config file, I would to be able to add in some kind of routine that would create a folder in a directory selected by the user. I would also like to be able to allow the program to check to make sure there is a connection to the database during every runtime. So far I've searched every where for a solution and have come across nothing so any information would be great. Thank you!

Martyn

Posted 12-Mar-12 10:36am

MartynL2011

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Mar-12 19:53pm

What folder? What directory? Relational databases based on client-server model work by URI and connection string. Don't you mix it up with filesystem-based databases? Or do I miss something?
--SA

MartynL2011 14-Mar-12 15:01pm

The Application isn't really server based so much. Its designed to be more package based where the user can import/export there databases to a chosen directory. But I would like the program to be able to remember and link up to the database after the program has been closed.

Sergey Alexandrovich Kryukov 14-Mar-12 19:27pm

Are you sure the database is really required? Such thing are very simply done with just an XML file.
Do you know the Data Contract?
--SA

MartynL2011 26-Mar-12 17:06pm

Sorry for such a late reply, I am required to create a database for part of my documentation. The database is used for storing a high amount of data and therefore can be monitored via sql.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ProEnggSoft · Accepted Answer · 2012-03-13T00:46:00

Solution 1

You can take a look at this article
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[^]

It may be helpful to you.

Posted 13-Mar-12 0:46am

ProEnggSoft

Comments

MartynL2011 14-Mar-12 15:03pm

Thank you, will look more into it. By the way I'm pretty new to "CodeProject" but looking through most of the questions I see that they seem to get 1 star votes. Is there some kind of spammer just giving bad votes?