Tutorials for configuring a db in Visual Studio

[cople]

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# database program. 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.)

[progcomputeach]

theres one particular site which is called

ConnectionStrings.com - Forgot that connection string? Get it here!

This is not a tutorial sites but it deals with connecting to different types of databases.

[cople]

Thanks, but as I said in my question, connections are not what I need help with.

[cople]

Anybody?

[Ancient Dragon]

This is a C/C++ SqlIte tutorial. I don't know how to integrate that with C#, shouldn't be too hard. If C# can call win32 api functions then it should be able to call all those SqlIte functions. I don't know if this link will help you or not, but it's an introduction example program written in C language.