In memory database wrapper for system.data.sqlite

Question

I am using system.data.sqlite for in memory testing, and i wanted to know if any of you got a link or knowledge for a open source project that simply create database and tables ?

For example :

InMemoryDB db = new  InMemoryDB();
Table t = new Table("myTable");
t.Add(new Coloum("Uid",DbType.VarChar,PrimeryKey = true));
db.Add(t);

or even a better idea ?

Thomas Levesque · Accepted Answer · 2012-09-16 18:57:52Z

4

Just use "Data Source=:memory:" as your connection string, and manipulate the DB directly in SQL

edited Sep 16, 2012 at 18:57

answered Aug 21, 2011 at 13:08

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

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

4 Comments

guyl Over a year ago

do you think if i create some generic project like that it would be helpful for developers ?

Thomas Levesque Over a year ago

A project to do what? create the DB schema from code? There are already tools that can do it, ORMs like Entity Framework or NHibernate

default.kramer Over a year ago

For some reason, this fails if I have the spaces around the = but it works fine if I use "Data Source=:memory:"

Thomas Levesque Over a year ago

@default.kramer, you're right, there was an error in my syntax. I fixed it.

Collectives™ on Stack Overflow

In memory database wrapper for system.data.sqlite

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related