1 reply to this topic

[mohd]

Hi guys!

I would like to make a simple app that would use a database. I only have experience using Oracle, but that is for web. I would like to learn how to use database in C#.

Can anyone teach me (us) the basics of how to do it? I'm using Microsoft Visual C# 2010. Thanks!

Sorry if this sounds noob. I am a noob. TIA!

=============

Edited by Alexander, 15 December 2010 - 09:21 PM.
Removed spam links.

[sam_coder]

it might take a few replys and a bit of back and fourth.

C# would by default access a database using ADO.NET.

There are a few basic concepts you need to understand.

You access the database through a type of data-context called a Connection.

The content in the database, is totally disconnected from data you work with, from within your application. You can translate to and from it using Command object.

(a command object requires context to the data (using the connection object))

You describe actions to the database, using SQL (structured query language)

that's about as sparse I can explain in this specific frame of mind. If you care to read, absorb, think about and ask a question, or simply ask me to talk on, my next post will explain how to connect to a database and execute basic requests against it.

If you give me a more specific example of what you're trying to do, I'll explain that too.

It's a really large topic, and a really broad question to ask. There's a lot to know and understand to work with databases effectively.