Re: [sqlite] sqlite-users Digest, Vol 125, Issue 28

[Abhishek Ginani]

I asked the same question on stackoverflow and got the answer. Please have
a look here  -

*https://stackoverflow.com/questions/50551624/sqlite-is-creating-a-disk-file-for-in-memory-db
*

Thanks for your help.

On Mon 28 May, 2018, 10:26 PM dmp,  wrote:

>
> > I tried to create a shareable in-memory database as per the documentation
> >  provided on SQLite  Site. But I end up finding the solution to the
> > problem.
> >
> > *Here is my code in C#*:
> >
> >
> > var connectionString = "Data
> > Source=sharedmemdb;Mode=Memory;Cache=Shared";
> >
> >
> > using (var connection1 = new SQLiteConnection(connectionString)) {
> > connection1.Open();
>
> I know nothing of C# or the argument requirements for SQLiteConnection(),
> but did you try:
>
> var connectionString = "Data Source=:memory:;Mode=Memory;Cache=Shared";
>
> or
>
> var connectionString = "Data
> Source=file::memory:;Mode=Memory;Cache=Shared";
>
> per the documentation.
>
> danap.
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 125, Issue 28

[dmp]

> I tried to create a shareable in-memory database as per the documentation
>  provided on SQLite  Site. But I end up finding the solution to the
> problem.
>
> *Here is my code in C#*:
>
>
> var connectionString = "Data
> Source=sharedmemdb;Mode=Memory;Cache=Shared";
>
>
> using (var connection1 = new SQLiteConnection(connectionString)) {
> connection1.Open();

I know nothing of C# or the argument requirements for SQLiteConnection(),
but did you try:

var connectionString = "Data Source=:memory:;Mode=Memory;Cache=Shared";

or

var connectionString = "Data Source=file::memory:;Mode=Memory;Cache=Shared";

per the documentation.

danap.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users