Is it possible to create a database when it's opened, and then create tables/indexes on the fly.
I have a class library that needs to create the database, create the tables, and then populate the tables.
And then the db will be read by an external program. Essentially i'm filling it with xml that needs to be cache, and then the external program reads the messages from db, and send them across a transport, wcf maybe.
Can it be done.
Any help would be appreciated.
Bob.
Create db on the fly.
Take a look at the FailIfMissing connection string property.
If it is set to false, a new database file is created with an empty database in it. Then you can execute ADO.NET commands to create the database objects.
Are you using any ORMs (Entity Framework or LinqConnect)?
If it is set to false, a new database file is created with an empty database in it. Then you can execute ADO.NET commands to create the database objects.
Are you using any ORMs (Entity Framework or LinqConnect)?
-
- Posts: 12
- Joined: Mon 24 Jan 2011 18:21
Hi AndreyR,
I saw that property. I've decided to create the database schema before hand using SQLiteStudio. It seems to be a better approach and SQLiteStudio seems reasonably decent.
The main question though is it possible to have db opened using your driver from two seperate processes. I have 1 app populating it a single table with xml messages, and another program (c# wcf) reading the same table and removing the xml messages and sending them to central db probably oracle.
I saw that property. I've decided to create the database schema before hand using SQLiteStudio. It seems to be a better approach and SQLiteStudio seems reasonably decent.
The main question though is it possible to have db opened using your driver from two seperate processes. I have 1 app populating it a single table with xml messages, and another program (c# wcf) reading the same table and removing the xml messages and sending them to central db probably oracle.
-
- Posts: 12
- Joined: Mon 24 Jan 2011 18:21
Multiprocess access.
Excellent.
That was what i've been looking for.
Thanks
Bob.
That was what i've been looking for.
Thanks
Bob.