Scripting SQLite database creation

Question

I'm generating Schema.sql file and I want programatically to create sqllite db file and execute all sql statements from file.

thanks

So far I was manually created db file with manually imported sql statements and now I want to move further and execute those programatically. So, I need some link examples, some site which point me to the right direction. — user1765862
– user1765862, Commented Jan 11, 2013 at 7:44
maybe this helps, Scripting SQLite database creation, swinbrain.ict.swin.edu.au/wiki/… — BobRock
– BobRock, Commented Jan 11, 2013 at 7:50

Owen Pauling · Accepted Answer · 2016-01-10 21:25:38Z

1

You can use the SchemaExport class to generate the scripts, and/or apply them to the database : http://nhibernate.info/doc/tutorials/first-nh-app/your-first-nhibernate-based-application.html

public class GenerateSchema_Fixture
{
    [Test]
    public void Can_generate_schema()
    {
        var cfg = new Configuration();
        cfg.Configure();
        cfg.AddAssembly(typeof (Product).Assembly);

        new SchemaExport(cfg).Execute(true /*script*/, true /*export to db*/,
                 false /*just drop*/, true /*format schema*/);
    }
}

edited Jan 10, 2016 at 21:25

Owen Pauling

12.1k20 gold badges58 silver badges67 bronze badges

answered Jan 11, 2013 at 7:58

mathieu

31.3k4 gold badges67 silver badges91 bronze badges

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

3 Comments

user1765862 Over a year ago

thanks for the answer but I already have generated Schema.sql, I'm struggle with how to execute those sql from the file into db. Thanks

user1765862 Over a year ago

ok, where should I find created sql db file. My schema.sql is generated inside C:\Program Files (x86)\Common Files\microsoft shared\DevServer\10.0, but db file is not there. Tried in bin and obj\Debug but again nothing

mathieu Over a year ago

It will be the SQLite db file specified in nhibernate connection string

Collectives™ on Stack Overflow

Scripting SQLite database creation

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related