Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Topics

Recent Status Updates

View All Updates

Photo
- - - - -

C# SQL database


  • Please log in to reply
1 reply to this topic

#1 mohd

mohd

    CC Lurker

  • Just Joined
  • Pip
  • 3 posts

Posted 15 December 2010 - 08:50 PM

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.

  • 0

#2 sam_coder

sam_coder

    CC Addict

  • Senior Member
  • PipPipPipPipPip
  • 380 posts

Posted 15 December 2010 - 09:01 PM

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.
  • 0




Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download