System.Data.SQLite

Hi there! 
 
I tried to use designer to build dbml schema of my database within MS VS 2008. It didn't work for me (I read manual and ran install.exe from designer folder before trying to use dbml UI). I got this error message from Studio: "The selected object(s) use an unsupported dataprovider". I wonder if I'm missing something here or if there are some workarounds available. 
 
Thanks, 
Dennis

What version (what edition) of VS2008?

My version is this:

Microsoft Visual Studio 2008
Version 9.0.21022.8 RTM
Microsoft .NET Framework
Version 3.5

Installed Edition: Enterprise

Can you give me a little more information about what steps you're taking to get the error so I can reproduce it?

Sure.

 These are my steps.

1. Install sql.data.sqlite after download.
2. While installing last step is a window that allows to select which IDE should desinger be integrated with. On this step MSVS 2008 is selected automatically for me (which is correct). So i just close the window with that checkbox set to ON. Note: I tried to run install.exe separately from install process. I checked and unchecked checkbox with MSVS2008 choice. I checked code of install.exe within reflector - and I noticed that some keys are created in registry. I opened registry editor and checked those keys - they are created correctly, as written in code of install.exe.
3. Run MSVS2008. Open project. Add .dbml schema to it (via right click on project -> Add Item -> Linq to Sql classes).
4. Open ServerExplorer and connect to my SQLite database.
5. Expand list of tables.
6. Drag table to the .dbml designer area.
7. Get an error (described in the opening post of this topic): "Selected item(s) use unsupported dataprovider".

Linq to Sql works with only one provider - MS SQL Server. You need VS 2008 SP1 beta with the Entity Framework and the latest release of SQLite.NET to design your database classes.