I'm trying to build a Windows Form application using VB 2010 Express, SQLCE 4.0, and LINQ 2 SQL. I'm new to both SQL and LINQ, and I'm having difficulty getting started. I've created a SDF database in the solution and two tables. I created
a DBML file, but cannot drag the tables to the design surface. I get an error message, "The selected object(s) use an unsupported data provider." The application Imports System.Data, System.Data.SqlServerCe, and System.Linq.
Here is a snippet of code that I've been attempting to use:
Dim dbName As String = "Quotes.sdf"
Dim dbPswd As String = "quotes"
Dim con As New SqlCeConnection("Data Source=|DataDirectory|\" & dbName & ";Password=" & dbPswd) ' & ";Persist Security Info=True")
View Complete Post