Problem with CreateDatabase SQLite

Problem with CreateDatabase SQLite

Postby julnisch » Tue 15 Oct 2013 21:12

Hey folks,

I am just trying to use the LinqConnect library within a new project.
I just created a model with the designer with the option model first.

So no I tryed to create the database at runtime but i always keep getting an error

When I execute:
_dataContext.CreateDatabase(false, true);

I get:
SQLite error
unknown database RE_EntranceSimple

Can someone post me an example how to create a SQLite database at runtime.

Thank you very much!
Best regards
Julian Nischler
julnisch
 
Posts: 2
Joined: Tue 15 Oct 2013 21:03

Re: Problem with CreateDatabase SQLite

Postby julnisch » Tue 15 Oct 2013 21:25

Just got it!

In the Model Settings you must set Target Schema to "main" with quotes!

Why is the model even using the "Target Schema" as SQLite only supports "main"!!!

Seems to be a bug!

Regards
Julian Nischler
julnisch
 
Posts: 2
Joined: Tue 15 Oct 2013 21:03

Re: Problem with CreateDatabase SQLite

Postby MariiaI » Wed 16 Oct 2013 07:39

We couldn't reproduce this issue in our environment with the latest build of LinqConnect 4.2.338. Please specify the version of LinqConnect you are working with and send us a test project with which this error could be reproduced so that we are able to investigate it in more details.
Looking forward to your reply.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)