Tutorials for .NET database app using SQLite

views:

169

answers:

+4 Q:

Tutorials for .NET database app using SQLite

I have some MS Access experience, and had a class on console c++ apps, now I am trying to develop my first program. It's a little C# db app. I have the db tables and columns planned and keyed into VS, but that's where I'm stuck. I'm needing C#/VS tutorials that will guide me on configuring relationships, datatyping, etc, on the db so I can get it ready for testing of the schema.

The only tutorials I've been able to find either talk about general db basics (ie, not helping me with VS/C#), or about C# communications with an existing SQL db.

Thank you.

(In case it matters, I'm using the open source System.Data.SQLite (sqlite.phxsoftware.com) for the db. I chose it over SQL Server CE after seeing a comparison between the two. Also I wanted a server-less version of SQL because this little app will be on other people's computers and I want to to do as little support as possible.)

+2 A:

SQL Server Compact - I would begin with SQL Server Compact as my database. SQL Server CE should be the easiest to setup with Visual Studio. Search Google for "SQL Server Compact Tutorial". There are quite a few.

I should mention SQL Server Compact Edition is a zero-install, single-file database like SQLite. But being a Microsoft technology you won't have to figure out SQLite.Net or SQLite itself to get started. And your query skills will migrate to SQL Server Express and SQL Server Standard.

Beginning ASP.Net Databases - Then I'd go with a good book. There are a lot of tutorials, but I think a well written beginners book is usually the best way to go.

What I usually do when I need to learn a new technology is to find a project I'd like to use it for and try to build that. Then I research any issues that I run into.

Let me know if you have any specific questions.

kervin 2010-03-21 02:49:58

Thanks kervin. Would me using SQLSCE be *a lot* easier than me using Sqlite? I chose SQLite based on a comparison of the two I saw (although I've forgotten what reasons stood out to me), and I'd like to use it if it's not *too* much harder. (I mean, I believe my SQLite is already installed and connected to VS.) Also, you say my query skills would translate to SQLSCE, does that mean they would translate less to SQLite?

ChrisC 2010-03-21 04:12:08

SQLite SQL Syntax verifies considerably from SQL Server. Not that either is especially hard to learn. But either would work well. Even SQL Express could fit in there too. Give them all a try, I'm sure you'll learn a lot more. But make sure you read a few good .Net books. I really like the APress "Beginning..." and "Pro..." books.

kervin 2010-03-21 04:26:27

So are you saying that, all things considered, me choosing SQLite isn't *too much* harder than SQLSCE?

ChrisC 2010-03-21 04:32:48

No, it's fine. I'd say if things aren't working out then give SQL CE or SQL Server Express a try.

kervin 2010-03-21 04:59:16

This guy's stuff is very well explained, especially when it comes to understanding the whole connection, dataset, data adapter etc. stuff.

http://www.youtube.com/watch?v=OJfYSZzZOP8

That's the first vid of 5, and he's got some other good vids as well. It's done in VS and C# with SQL.

mdvaldosta 2010-03-21 03:05:56

Do his instructions also apply to System.Data.SQLite (sqlite.phxsoftware.com)? If so, I'll watch them fully later, but unfortunately he doesn't help with configuring a db much (relationships, proper types, etc), he is just talking about how to communicate with it.

ChrisC 2010-03-21 04:25:17

ansaurus

tags:

views:

answers:

Tutorials for .NET database app using SQLite

related questions