SQL Server CE string errors on .dbo. syntax

Question

A following question to this SO question

I'm using a SQL Server CE database included in the c# winforms project

The following does not work but if I amend the SQL string to

SELECT * FROM helloworld

then it does work. Why? Is there a full path that I could use

SELECT * FROM <blah>.<blah>.helloworld

?

using (var conn = new SqlCeConnection(ConfigurationManager.ConnectionStrings["DatabaseDGVexperiments.Properties.Settings.DatabaseDGVexperimentsConnStg"].ConnectionString))
{
    conn.Open();

    using (var myAdapt = new SqlCeDataAdapter("SELECT * FROM experiment.dbo.helloworld", conn))
    {
        DataSet mySet = new DataSet();
        myAdapt.Fill(mySet, "AvailableValues");
        DataTable myTable = mySet.Tables["AvailableValues"];
        this.uxExperimentDGV.DataSource = myTable;
    }
}

Why would you want to do that? SQL CE doesn't have multiple schemas/catalogs like SQL Server — Thomas Levesque, Jun 09 '12 at 17:33
ok - so SqlCe only has a single db, therefore no further information will ever be required. — whytheq, Jun 09 '12 at 17:36

score 1 · Accepted Answer · answered Dec 30 '12 at 21:12

1

SQL CE doesn't have multiple schemas/catalogs like SQL Server (ref Thomas Levesque Jun 9) Therefore no further information will ever be required in the FROM clause

answered Dec 30 '12 at 21:12

whytheq

34,466
65
172
267

SQL Server CE string errors on .dbo. syntax

1 Answers1