Tutorials for configuring a SQLite db

[Cope]

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# SQLite database program. I have the db tables and columns planned and keyed into the new project in VS, but that's where I'm stuck. I'm needing VS tutorials that will guide me on configuring relationships, datatyping, etc, on the db so I can get it ready for the 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#), MS databases, or C# communications with an existing SQL db.

Thank you.

[Arjay]

http://www.bing.com/search?q=SQLite+Visual+Studio+tutorial&form=QBLH&qs=n

[Cope]

Arjay, I appreciate your reply, unfortunately that's about what I've found before I posted this question. The results of that and other searches I've done pull mostly "how do I communicate with a sqlite db?" and only very slightly touch on "configuring a sqlite db in VS". But the latter is what I am needing right now, so that then I can test my db structure. I tried to draw that difference in my question.

[Arjay]

The 4th result in the query I gave you is:

http://www.eggheadcafe.com/tutorials/aspnet/20f7912e-6fa7-40eb-b31b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx

which is described as:

How to get started using SQLite with Designer Support in Visual Studio


This seems to go over the basics. What else are you looking for?

[hj_simpson]

As an alternative to configuring with VS I use:

http://sqliteadmin.orbmu2k.de/

[Cope]

The 4th result in the query I gave you is:

http://www.eggheadcafe.com/tutorials/aspnet/20f7912e-6fa7-40eb-b31b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx

which is described as:


This seems to go over the basics. What else are you looking for?

Maybe due to my inexperience my question isn't clear enough, but I explained what I'm looking for as well as I could. At this point I really don't know how to reword it any better. When you first replied with your link I looked at that page, but it doesn't show any configuration of the db, and the db only contained one table. Therefore no relationships, etc. The tutorials returned by the Bing search you linked to are typical of what I've found so far, and I'm hoping someone can point me to ones that are more focused on my situation.

[Cope]

As an alternative to configuring with VS I use:

http://sqliteadmin.orbmu2k.de/

Interesting. What reasons did you have for choosing to use this instead of VS for configuring? I'm wondering if your reasons might apply to me. And, dumb question, what all does it do?

[Cope]

HJ_Simpson, you there?