Create table with Linq to Sqlite (linq2db)

Question

What I'm trying to do is to create a table on the fly, when a connection is opened on an empty database. I've already created the model with Linq to Sqlite and successfully used it with non-empty databases.

Now I'm trying to work with "new" databases.

I do my db.Insert like this:

    using (MyDB db = MyDB("MyConnectionName"))
    {
            Person d = new Person()
            {
                name = "mimi"
            };

            db.Insert(d);

            myLabel.Content = db.Drivers.First().name;
        }
    }

An empty database is opened OK. Actually a 0KB file is created for it. But when I try to insert something into it (or of course read something) I get an exception: SQL logic error or missing database

The library I'm using:

https://github.com/linq2db/linq2db

The NuGet package:

http://nuget.org/packages/linq2db.SQLite/

Is there something I need to do before start writing to an empty database file?

Don't know anything about linq2db, but not every linq provider will support creating of data tables. You may have to either ship a empty database, or create the tables using TSql 'Create table' commands. — sgmoore
– sgmoore, Commented Jun 1, 2013 at 13:22

Andrey Efimov · Accepted Answer · 2015-10-14 07:37:35Z

16

Linq2DB doesn't create tables automatically. So you have to check whether table exists and if not-create it. You can do it this way:

    var sp = db.DataProvider.GetSchemaProvider();
    var dbSchema = sp.GetSchema(db);
    if(!dbSchema.Tables.Any(t => t.TableName == "Person"))
    {
       //no required table-create it
       db.CreateTable<Person>();
    }

Unfortunately there is some lack of documentation. But you can use test sample.

answered Oct 14, 2015 at 7:37

Andrey Efimov

4665 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kieran Devlin · Accepted Answer · 2024-04-03 15:11:39Z

5

To expand upon Andrey Efimov's answer, rather than implementing your own query to the schema to see if the table exists and conditionally creating the table, there is a built in property to only create the table if its necessary.

connection.CreateTable<MyEntity>(tableOptions: TableOptions.CheckExistence);

answered Apr 3, 2024 at 15:11

Kieran Devlin

1,4531 gold badge14 silver badges29 bronze badges

Comments

user2090264 · Accepted Answer · 2014-05-19 00:48:18Z

-4

you don't open the database.

MyDB db = MyDB("MyConnectionName") <- Create Database.

db.open(); <- add this.

then you will operate ordinarily.

answered May 19, 2014 at 0:48

user2090264

51 silver badge3 bronze badges

Collectives™ on Stack Overflow

Create table with Linq to Sqlite (linq2db)

Is there something I need to do before start writing to an empty database file?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Is there something I need to do before start writing to an empty database file?

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related