Database, which the best method for use.

Question

1.00/5 (1 vote)

See more:

Hi guys, i'm beginner programming on c#, i wanted know which the best form i may use for connect my database with my system.

Thanks

Posted 1-Sep-12 8:38am

diegofoca

Add a Solution

Comments

Kenneth Haugland 1-Sep-12 14:39pm

Depend on you rrequirements I would guess... What do you want to use it for?

bbirajdar 1-Sep-12 14:47pm

There are in all 138 ways to connect to the database in .net and the 12th method is the best...

diegofoca 1-Sep-12 14:52pm

My system register clients in a hairdresser, but when load the tables clients, my system opens slow.

ridoy 1-Sep-12 15:06pm

it depends on you..on which system you will develop and on which method you will be interested.But i will recommend you to use SQL database form.

diegofoca 4-Sep-12 7:59am

It's ok, i used access for building system, this is not good form ?

ridoy 4-Sep-12 10:22am

Of course,if you think it will fulfill your requirement..

2 solutions

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)

Philip Stuyck · Answer 1 · 2012-09-01T08:47:00

Solution 1

If you are a beginner I would start with strong typed datasets and use dataadapters to fetch the data and perform the updates.
Next step might be to use an sql command yourself to fetch data and perform updates.
Going more advanced is using an entity framework.
The question is a bit generic, so my answer is a bit open too. If you have more specific questions I'll gladly answer.

Posted 1-Sep-12 8:47am

Philip Stuyck

Comments

diegofoca 5-Sep-12 14:31pm

Ok, i use dataadapters at the moment, when i learn more i can use entity framework ?

Philip Stuyck 5-Sep-12 15:40pm

sure, but if you encounter problems using the entity framework it help to have some knowledge about what is going on underneith. Entity framework shields database stuff from you, nevertheless you have to know what you are doing.

Sourav Sarkar-SS · Answer 2 · 2012-09-01T08:47:00

There are two environment Connected and disconnected.
Connected: when there is 1-1 (server-Client) its very helpful..
Disconnected : When may clent-1/many server its helpful.

in case case of connected you can directly execute the Command Object.
but in case of disconnected you need to take help of temporary Dataset object.

okey.
these link will be helpful for you.
Connect Database with C#

connected and disconnected Environment

difference between Connected and Disconnected Architecture