4 Replies - 599 Views - Last Post: 12 November 2010 - 08:38 AM Rate Topic: -----

#1 Guest_Guest*


Reputation:

getting started with dbs

Posted 11 November 2010 - 09:46 AM

i thinking of starting to learn connecting a c# program to a database and was wondering what type to go with. in my vb.net class we tested out how to do it with an access database, but i figure sql might be better. i tried to download mysql but couldn't figure out how to make my tables.

someone said sqllite which i was thinking of looking into as well.

i want to prevent access, not that it would be really important since its no personal data, and may be used locally only, not online. also in my vb.net class we learned how to design our interface by just dragging the table onto the form and letting visual studio set everything up for us. is there a better way to do it?

i am just looking to get started so i need pointed in the rigth direction. also any tutorials for the respective database and connecting would be good too.

thanks

Is This A Good Question/Topic? 0

Replies To: getting started with dbs

#2 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6066
  • View blog
  • Posts: 23,526
  • Joined: 23-August 08

Re: getting started with dbs

Posted 11 November 2010 - 09:50 AM

SQL Basics in C#. There are even more in those tutorials if you search them.
Was This Post Helpful? 1
  • +
  • -

#3 erburrell  Icon User is online

  • D.I.C Head
  • member icon

Reputation: 10
  • View blog
  • Posts: 146
  • Joined: 22-December 09

Re: getting started with dbs

Posted 11 November 2010 - 10:42 AM

Also, if you want to use MySQL, there is a tool provided by them to manage your databases, or you can try Navicat. They have a non-comercial free version that would probably work nicely for you.

If you are going to get deep into databases, I would also suggest that you check out NHibernate and FluentNhibernate. They are open-source, and make the programming a whole lot easier. FlashM made a great tutorial for starting with Fluent here.

You can also look at using Linq.

Good Luck.

Ed.
Was This Post Helpful? 0
  • +
  • -

#4 Guest_Guest*


Reputation:

Re: getting started with dbs

Posted 12 November 2010 - 08:31 AM

does sqllite have a gui for editing the tables?
Was This Post Helpful? 0

#5 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6066
  • View blog
  • Posts: 23,526
  • Joined: 23-August 08

Re: getting started with dbs

Posted 12 November 2010 - 08:38 AM

http://tinyurl.com/29gu9et
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1