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
getting started with dbsbut what type?
Page 1 of 1
4 Replies - 493 Views - Last Post: 12 November 2010 - 08:38 AM
Replies To: getting started with dbs
#2
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.
#3
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.
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.
#4 Guest_Guest*
Re: getting started with dbs
Posted 12 November 2010 - 08:31 AM
does sqllite have a gui for editing the tables?
Page 1 of 1
|
|

New Topic/Question
Reply
MultiQuote








|