How To

Help with a MSSQL Convert

tknman0700 — Thu, 02 Sep 2010 21:22:57 GMT

I am trying to convert my MS SQL knowledge into SQLite and having a bit of a problem... my biggest concern here is lack of variable and stored procedure support so I am trying to understand how to make this all work.

When I do this...

Dim sql As String = "insert into tblRecords2(CRC) values ('866A463AF32A4BF102E532AAD9E621');insert into tblDataRecords(dataID,chunkID,chunkSequence) values (1, last_insert_rowid(),1)"
            Dim slc As New SQLite.SQLiteConnection("data source=C:\Users\m001kah\Desktop\Services.db")
            Dim slcmd As New SQLite.SQLiteCommand(slc)
            Dim slda As New SQLite.SQLiteDataAdapter()

            slda.SelectCommand = slcmd
            slda.Fill(dt)

            If Not IsNothing(dt) Then
                If dt.Rows.Count > 0 Then
                    chunkID = dt.Rows(0).Item(0)
                End If
            End If

I get an exception: Value cannot be null. Parameter name: s

First off I dont know that this means... help please.

Secondly I have been testing the SQL statement in SQLRazor and I see that the last_insert_rowid() is 0 but the insert into tblRecords2 actually worked.... arghh.. please advise.

Thanks

How to use CHAR's ?

Marc — Tue, 31 Aug 2010 15:22:47 GMT

Hi,

I created a table with a CHAR column in it, like this:

CREATE TABLE ClientData(...., Status CHAR(1) NULL, ...)

When inserting data i use a parameter with DbType.Byte.

But when I read the data using a DataReader (SQLiteDataReader) and try the following code

char x = dataReader.GetChar(10);

i get:

Specified cast is not valid.
at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
at System.Data.SQLite.SQLiteDataReader.GetChar(Int32 i)

I tried debugging this and I see that in the reader the column has an SQLiteType with Type=String and Affinity=Null and it is the Affinity=Null that is causing the exception.

Can you tell me where i went wrong ?

Thanks in advance.

Question about using 32-bit and 64-bit libraries

aravenwood — Wed, 27 Jan 2010 05:11:04 GMT

Hi - I've read several of the posts in the forum about using 32-bit/64-bit versions of sqlite.net but I am still in the dark about whether certain things are possible or how to go about doing this properly. Here is my issue: I have a vb.net windows forms app using .net framework 2.0 via VS2008. This application uses sqlite.net to access sql databases. I am in the process of creating my setup/installer for the application, and will use the installer creation capability in VS2008. For reference my app was originally a vb6 app that I upgraded, and added the capability to access sqlite. To reach the broadest audience possible, I would like for my app to run on both 32-bit and 64-bit Windows platforms. To keep things as *simple* as possible to maintain, I would like to have only one setup/installer which will install an application that will run on either 32-bit or 64-bit Windows. To do this I set my compile settings to "any cpu". My understanding from reading the forums here is that sqlite has both 32-bit and 64-bit versions, but there is not a single version that runs on both primarily because sqlite (which is include in the sqlite.net assembly) does not have a binary that will work on both 32-bit and 64-bit. 1) Is this understanding correct? And is the implication that I must have two separate versions of my - one for 64-bit which includes the 64-bit version of sqlite.net and one for 32-bit which includes 320bit sqlite.net? If this is not true, how do I get, and use the assembly that runs on both types of OS'es? 2) If I need to have the 32-bit assembly for 32-bit systems and the 64-bit assembly for 64-bit systems, is there any way to include *both* the 32-bit and the 64-bit versions of sqlite.net in my application and how do I set things up so that it would autosense which is the correct assembly to use depending on type (32-bit/64-bit) of the OS? Apologies if my post is not clear or if this already answered in another post, but I am a bit of Noob with .net and do not understand it completely yet. Any help, comments, suggestions, examples or links that could help with this issue is appreciated. Thanks in advance, Michael

Invalid database Path

kumander — Thu, 19 Aug 2010 11:01:15 GMT

hello to all

i have a problem on connecting to database coz its always says invalid path i'm using windows mobile 5.0 .net 2005 my code is vb, i'm running in my local pc emulator what should i do to connect to database what correct connection string or where should i put my database..please help

thanks

What is the query to check if an attribute in a table existed or not?

xhnguyen — Tue, 10 Aug 2010 08:30:25 GMT

Hi, The question is in the title is clear, I guess. What/how is the query to check if an attribute in a table existed or not? I am doing with SQLite. Thanks in advance.

How I get DatabaseObjects and DatabaseObjectsProperties

edgarchiroleo — Thu, 05 Aug 2010 16:00:59 GMT

Hi, i'm writing an application in C# and need to know how to get DatabaseObjects and DatabaseObjectsProperties of my database in SQLite. For example, in SQL2005 obtain DatabaseObjects is in this way:

SET NOEXEC OFF
    select name, xtype, id
    from [{0}].dbo.sysobjects
    where name like ('{1}%') and xtype in ('U','V')
    order by xtype, name

How a can do this for SQLite

Thanks.

How do I fetch the schema of the tables & associated metadata?

Sourjya Sankar Sen — Sun, 30 Apr 2006 14:53:52 GMT

    Hi,
         I'm totally new to SQLite and am just a little familiar with the ADODB classes. I'm trying to design a simple database and table creation tool using C# on .NET 2.0. So far I've been able to create databases and tables using the ADO.NET wrapper found here. But where I'm failing is to read the table metadata back and displaying it on screen. I can't figure out the exact code to do this. Now my code works kind of one-way :D i.e., you can create tables - but cannot see the columns/indices and other associated metadata. Can anyone provide me with a code sample as to how to do this?

        What I did try though - was to pass a "DESCRIBE tablename" statement through the ADO.NET Provider to SQLite, hoping it would return the structure of the table, from where I can parse the data and show on screen. But DESCRIBE doesn't seem to work on SQLite.. (I know there's a .describe command - but that works only with the command line tool)

       Any help will be greatly appreciated. Code samples would be even better :)

Thanks,
m^e

how to write and invoke your own UDF in any .NET language?

timo888 — Mon, 26 Jul 2010 13:13:32 GMT

The description of the phxsoftware SQlite connectivity layer has this: User-Defined Functions & Collating Sequences Full support for user-defined functions and collating sequences means that in many cases if SQLite doesn't have a feature, you can write it yourself in your favorite .NET language. Writing UDF's and collating sequences has never been easier. Could someone give a bare-bones example of the steps involved in writing UDFs for SQLite "in your favorite .NET language", or provide a link where this is described in detail? Thanks

I am looking for a sample how to retrieve data from 2 tables, get a ResultSet and read the data

Eluim — Sun, 25 Jul 2010 17:37:05 GMT

Anyone could provide a simple code snippet in c#?

sqlite connect excel

chris23879 — Sun, 25 Jul 2010 11:14:27 GMT

Hi Guys,

I have an sqlite database that i would like to extract data from, into and excel workbook.

Please could somebody recomend the best way to do this.

I belive this can be dome using ODBC in the .net framework.

There is a reference to using ODBC on http://www.connectionstrings.com/sqlite.

The following is my an attempt.

Global cnPubs As New Connection

Sub OpenConnection()
    ' Provide the connection string.
    Dim strConn As String
    'Use the SQL Server OLE DB Provider.
    strConn = "DRIVER=SQLite3 ODBC Driver;Database=H:\New Folder (2)\2010_06_11\aquagib2.sqlite;"
    'Now open the connection.
    cnPubs.Open strConn
End Sub

Regards

Chris

Can't view SQLite.Interop vcproj properties for x64

chadmein — Tue, 20 Jul 2010 21:20:20 GMT

I'm trying to build the x64 version of the System.Data.SQLite.dll from source code and wanted to check the properties on the project file but I get an error...

"The operation could not be completed. Unspecified error."

If I change the platform from x64 to Win32 in the ConfigurationManager I can view the properties just fine. It's only when the platform on the solution is set to x64 that it causes this error.

I'm using an older version 1.0.62 because I need to be on a specific version of the sqlite3.c file and this version of the System.Data.SQLite was the closest to that version.

Any help on how to fix this would be appreciated.

Thanks!

Do not call command.Text =... in a Delete/Insert loop, how make it better?

Eluim — Mon, 19 Jul 2010 19:07:37 GMT

I have this c# method: http://pastebin.com/KtNMpqrG I do not know how I can take the com.CommandText and Parameters.Add out of the foreach loop. How would you do that?

Can't find PInvoke DLL "SQLite,Interop.DLL" on WinCE 4.1

mhoop81 — Tue, 20 Jul 2010 12:56:49 GMT

I have a scanner app that I've written. SQLite .066 works fine on 4.2 and higher, but I'm getting a message Can't find PInvoke DLL 'SQLite.Interop.DLL'. on the 4.1. Could someone suggest a solution?

How to read related data from 2 tables into an aggregated collection?

Eluim — Sun, 18 Jul 2010 10:56:38 GMT

Hello, I have 2 methods. Both work fine for its own... What I want is to retrieve with SQLite the SchoolclassCodeID from every pupil with the current SchoolclassCode and its SchoolclassCodeID property. In the end I want to return a ObservableCollection where each SchoolclassCode object has 1 ObservableCollection with many pupil objects. How would you do that with sqlite, 2 readers, 2 SQLiteCommands, 2 while loops etc...?


public IEnumerable GetSchoolclassCodeList()
        { 
            using (var trans = ConnectionManager.Connection.BeginTransaction())
            {
                SQLiteDataReader reader = null;
                try
                {
                    using (var com = new SQLiteCommand(ConnectionManager.Connection))
                    {
                        com.CommandText = "SELECT * FROM SCHOOLCLASSCODE";                        
                        reader = com.ExecuteReader();

                        while (reader.Read())
                            yield return new SchoolclassCode() { SchoolclassCodeID = reader.GetInt32(0), SchoolclassName = reader.GetString(1) };                                                       
                    }
                    trans.Commit();                   
                }
                finally { reader.Close(); }
            }
        }

        public IEnumerable GetPupilList()
        {          
            using (var trans = ConnectionManager.Connection.BeginTransaction())
            {
                SQLiteDataReader reader = null;
                try
                {
                    using (var com = new SQLiteCommand(ConnectionManager.Connection))
                    {
                        com.CommandText = "SELECT * FROM PUPIL";
                        reader = com.ExecuteReader();

                        while (reader.Read())
                            yield return new Pupil() { PupilID = reader.GetInt32(0), FirstName = reader.GetString(1), LastName = reader.GetString(2), SchoolclassCodeID = reader.GetInt32(3) };
                    }
                    trans.Commit();
                }                
                finally { reader.Close(); }
            }
        }

Sample for DataGridView binding

m_ologin — Wed, 11 Nov 2009 00:15:45 GMT

Please redirect me if this has already been posted somewhere, but I've been looking all over for a simple full example of a C# DataGridView sample that binds a table to a database table and performs CRUD operations directly on it.

Does this exist anywhere? It seems like the first thing that should have come with this library...

publish my project error!

jviure — Tue, 13 Jul 2010 13:50:59 GMT

Hello people! I'm writing a desktop application using sqlite as database. I want to give a CD to a user and only installing the setup.exe start working. I thought to use the sql server ce but finally I use sqlite. What happens is that if I execute the application in visual studio with debug or release mode the application runs perfect (I copied before my sqlite db in application_folder/bin/debug and application_folder/bin/release). But if I publish the application and try to execute the application in another computer this error is thrown:

http://www.glowfoto.com/static_image/13-080942L/4684/png/07/2010/img4/glowfoto

If I execute the application in my computer but out of visual studio this error is not thrown but no database is found. Can you help how to continue? I wat to give this application to a friend but actually I can't for this problems.

Thanks! :)

Dataset Update with DataAdapter and CommandBuilder Problem

Tink — Thu, 08 Jul 2010 15:44:43 GMT

Hello,

New user here - evaluating SQLite in ADO to see if it can replace an existing database...

Before I post any code along with my problem, I thought I would first describe it in case the answer was immediately obvious, because as I wrote above I am new to all of this.

PREVIOUS database was an Access (JET) database using Microsoft's ADO.NET with an OLEDB data adapter. The way the application was architected, it would read (for example) 3 tables into a single DataSet, and use the OLEDB adapter to include schema information. The DataSet was passed to another procedure where the data was compared with objects in memory and changes were made, then the DataSet was passed back to yet another procedure that would actually apply the updates. In this scenario, the DataAdapter was not maintained through the procedures - a different adapter/connection was used for the update from the one that was originally used to fill the DataSet with the 3 tables. (The 3 tables are related but not through a JOIN or anything like that.)

So here is the problem...

I first updated the procedures, not wanting to rewrite them entirely, and of course the update complained about not having the select statement/update statement. So, I then added the CommandBuilder, but without the proper DataAdapter that of course did nothing either. So then, I initialized a new data adapter (similiar select clause) but did not use it to fill the dataset (since it was already filled and modified), and used that to create the CommandBuilder. However, while it returns no errors, it also does not apply a single update to the database!

So then I finally went and created an object that when the DataSet was created, would hold the resulting DataSet as well as the 3 DataAdapters used to get and fill the DataSet with the 3 tables. I then passed those DataAdapters to the procedure that does the Update, but as you might guess, no joy. It does not throw any errors/exceptions, it just does nothing to the table.

Any guesses as to what is wrong?

Here is just a small snippet of the actual update procedure...

        Dim dc As SQLiteCommandBuilder
        Dim da As SQLiteDataAdapter

        Try
            da = dsda.DA1
            dc = New SQLiteCommandBuilder(da)
            Try
                ds.AcceptChanges()
                da.Update(ds, "Events")
            Catch ex As Exception
                WriteMon("Error", "SaveEvents(a) Error: " & ex.Message)
                Exit Sub
            Finally
                da.Dispose()
            End Try
      .....(rest of the procedure) .....

VS 2008 C++ samples

stutak — Wed, 03 Feb 2010 18:24:44 GMT

Hi all.

Can someone give me working c++ forms sample?

Because I cant find some tutorial/man and recieving lot of error...

For example:

    System::String^ connection_string = "Data Source=C:\\test.db";
    SQLiteConnection con = gcnew SQLiteConnection(connection_string);
    con.Open();
    SQLiteCommand cmd = gcnew SQLiteCommand(con);     // Here I've got error and I was unable to link command with connection(if I'll write this code:

cmd.connection=con;//cannot convert parameter 1 from 'System::Data::SQLite::SQLiteConnection' to 'System::Data::Common::DbConnection ^'

)

Would be great if someone got working c++ samples for:

1. Open database;

2. Insert data;

3. Read and display data; (is there way to read data in array[ ][ ] or something? )

Thank You for this product.

Data Grid filling using SQLite

nXqd — Wed, 23 Jun 2010 15:54:34 GMT

I'm new to dataGrid filling by database . I've implemented to fill my datagrid with datas from a TABLE. But know I want to have a search text box, so I can search through my database and show only record that match string. Example my TABLE: CREATE TABLE [DAUSACH] ( [MaSach] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [TenSach] char(20) NULL, [TheLoai] char(15) NULL, [TacGia] char(50) NULL, [LuongTon] int NULL ) This is what I do in windows form to fill my grid with all records from DAUSACH dAUSACHTableAdapter.Fill(qLNSDataSet.DAUSACH);

HOWTO compiling my own...

carleton — Sun, 13 Jun 2010 19:36:52 GMT

I would like to compile my own version of System.Data.SQLite. I am using it in a standard .Net 3.5 project, not special other than the fact I have applied a patch that forces foreign keys to be on by default. I see there are three different project variants of the System.Data.SQLite, Compact, ManagedOnly, and Netmodule. What is the difference? Which one should I be using?

Sam

Writing parameterized queries

Robert Simpson — Mon, 21 Nov 2005 20:30:42 GMT

Parameterized queries are something often overlooked by developers. It either looks confusing, or can't possibly be that important, or the developer wants more fine-tuned control over their queries, the excuses go on. If you're even remotely interested in maximizing performance, reducing SQL injection risks, or are deciding whether or not its worthwhile to rewrite your code to use parameterized queries, then please read on! If you already know all about parameterized queries, just skip to the end and read the syntax. Perhaps the single greatest feature of parameterized queries is that every major database engine takes advantage of them! What follows applies to all major database engines, not just SQLite:

First things first. SQL (Structured Query Language) is an interpreted language. Every time you execute a new SQL query the contents of the query must be parsed, an execution plan developed, memory allocated, etc. Parsing SQL is an expensive operation, though usually not as expensive as accessing the underlying data the query references. The decision on when to use paramterized queries is often influenced by a couple of factors:

Does the query involve input from the user?
Am I executing essentially the same statement with slightly different input values repeatedly?

If your code does either of these, you should consider using parameterized queries. Take for example, the following loop:

string lookupValue;
using (SQLiteCommand cmd = cnn.CreateCommand())
{
  for (int i = 0; i < 100; i++)
  {
    lookupValue = getSomeLookupValue(i);
    cmd.CommandText = @"UPDATE [Foo] SET [Value] = [Value] + 1
                        WHERE [Customer] LIKE '" + lookupValue + "'";
    cmd.ExecuteNonQuery();

  }
}

Now this code may look innocent enough, but it suffers some performance penalties and some security risks. First, the CommandText has to be re-evaluated every time the command is executed. SQLite must parse the statement and construct a query plan 100 times in this loop. There are also a lot of memory allocations being done here. The previously-prepared CommandText is freed, the new CommandText allocated. A statement is compiled and strings are concatenated causing even more allocations and deallocations. There are also a great number of interop calls being performed behind the scenes.

If lookupValue is unknown, provided by the user, or can be altered externally, this statement becomes a risk for an injection attack. Imagine what would happen if the lookupValue contained the string '; DELETE FROM Foo; SELECT '

Now put that statement together and you have:

UPDATE [Foo] SET [Value] = [Value] + 1
WHERE [Customer] LIKE ''; DELETE FROM Foo; SELECT ''

Now this is a disastrous injection attack. The very least you'll have to do to defend against this is double any single quotes that may appear in lookupValue, which of course is yet another step in the whole loop that will slow things down.

Parameterized queries provide a means to minimize all this impact. With a parameterized query, the CommandText is set only once at the beginning of the loop. The lookupValue becomes a parameter, assigned within the loop, and the command is executed over and over without having to do any extra parsing. Furthermore, since the parameter is a string variable and the SQL statement has already been prepared, it is not vulnerable to an injection attack.

SQLite supports named and unnamed parameters. Named parameters must appear in the SQL statement with either a $ (dollar), : (colon) or @ (at sign) prefix. Unnamed parameters consist of a single question mark ? character. Rewriting the above code to use a named parameter looks like this:

using (SQLiteCommand cmd = cnn.CreateCommand())
{
  cmd.CommandText = @"UPDATE [Foo] SET [Value] = [Value] + 1
                      WHERE [Customer] LIKE @lookupValue";
  SQLiteParameter lookupValue = new SQLiteParameter("@lookupValue");
  cmd.Parameters.Add(lookupValue);
 
  for (int i = 0; i < 100; i++)
  {
    lookupValue.Value = getSomeLookupValue(i);
    cmd.ExecuteNonQuery();

  }
}

The same code now using an unnamed parameter (compatible with Jet/Access)

using (SQLiteCommand cmd = cnn.CreateCommand())
{
  cmd.CommandText = @"UPDATE [Foo] SET [Value] = [Value] + 1
                      WHERE [Customer] LIKE ?";
  SQLiteParameter lookupValue = new SQLiteParameter();
  cmd.Parameters.Add(lookupValue);
 
  for (int i = 0; i < 100; i++)
  {
    lookupValue.Value = getSomeLookupValue(i);
    cmd.ExecuteNonQuery();

  }
}

For simplicity I didn't wrap these functions inside a transaction which would have made them significantly faster. Even still, the amount of processing that must be done for the parameterized queries are a fraction of the original. When performing a bulk update or insert, or executing a query using outside information, parameterized queries are a clear winner.

Robert

Can't Find PInvoke DLL SQLite.Interop.DLL - I copied it to project root but still not working

Gus — Thu, 29 Apr 2010 07:03:58 GMT

It's kind of regular problem there. But I can do nothing for it. Pls help me find it out, thanks a lot.

.NET 2.0 + VS 2005 + windows mobile 6 pro + C#

I have copied the CF version of System.Data.SQLite.DLL and SQLite.Interop.066.DLL.

Whatever I did, on real device (build app cab, include SQLite.Interop.DLL) or use emulator (I'm so sure that I followed the solution of other cases like this), it always show the error msg - Can't Find PInvoke DLL SQLite.Interop.DLL.

tks

Inserting cyrillic with parameter

jaynakus — Wed, 16 Jun 2010 20:34:01 GMT

What should I do to insert cyrillic text with parameters?

Where I insert the data is something like Р‘РёС„РѕСЃРёРЅ it is truly not cyrillic.

However, when I try to insert by other management application like SQLite Administrator to the same db it is ok.

What is wrong with my Insert command? It is has named parameters, and values are given normally.

"insert into sos12(id,naimex) values(@id,@naimex)"

where datatype of naimex is text

Please help....

Retrieving BLOB data from an old sqlite database

skyjt — Sat, 05 Jun 2010 17:42:55 GMT

Hi!

I had been using a C++ wrapper for SQLite to store image data as BLOBs in a table. Before the data is stored, it was encoded using the old sqlite_encode_binary function (which I think is no longer available). So my problem is that after porting the code to C#, the data which used to be stored in the database can no longer to retrieved with System.Data.SQLite without some transformation.

I managed to find the source code for the sqlite_decode_binary function and managed to transform the data back into JPEG data with some success, but the images are still corrupted (will display but has corrupted lines, some more so than others). I suspect that when the file is read as a BLOB, there is some level of decoding done (perhaps to properly encode certain characters?) before it is read back out. However, I can't seem to figure out what this decoding is. Would anyone be able to help?

Thanks!
Jerome

Using the Backup API

abrakjamson — Thu, 10 Jun 2010 23:18:15 GMT

If you're here, you've realized that System.Data.SQLite does not support the SQLite Online Backup API. If you absolutely can't wait until it is supported, I've found a solution.

If you want to copy a .db3 file to another .db3 file, you should either use the copy file API of your operating system, or RogerIrwin's method. Use the following method only if you need to back up your in-memory database and you like kludgey solutions.

This will require downloading the System.Data.SQLite source, modifying it, and recompiling. Basically, you need to be able to access the _sql property of the SQLite3.cs class.

Make the following classes public:

SQLite3
SQLiteBase
SQLiteConnection
SQLiteConvert
CriticalHandle and SQLiteConnectionHandle in UnsafeNativeMethods.cs

Make a public accessor for the _sql property of the SQLiteConnection class. This will allow you to retrieve the SQLite3 object created with your connection.

Make a public accessor for the _sql property of the SQLite3 class. Mine returns an IntPtr instead of a SQLiteConnectionHandle so it doesn't have to be converted later. This allows you to get the handle of your database to use in the API.

When you compile, make sure to use Release mode, and select the platform you are using. The dll that is created should be closer to 800kB than 100kB.

Now, in your project you need to link some external functions manually.


        [DllImport("System.Data.SQLite.DLL", CharSet = CharSet.Auto)]

        internal static extern int sqlite3_open(byte[] filename, out IntPtr db);



        [DllImport("System.Data.SQLite.DLL", CharSet = CharSet.Auto)]

        internal static extern int sqlite3_close(IntPtr db);



        [DllImport("System.Data.SQLite.DLL", CharSet = CharSet.Auto)]

        internal static extern IntPtr sqlite3_backup_init(IntPtr destDb, byte[] destname, IntPtr srcDB, byte[] srcname);



        [DllImport("System.Data.SQLite.DLL", CharSet = CharSet.Auto)]

        internal static extern int sqlite3_backup_step(IntPtr backup, int pages);



        [DllImport("System.Data.SQLite.DLL", CharSet = CharSet.Auto)]

        internal static extern int sqlite3_backup_finish(IntPtr backup);

And here is my method to do the backup.


/// summary

/// Backs up the in-memory database to the specified file.

/// /summary

/// param name="filename" The filename. /param

/// returns 0 if successful; otherwise, an SQLite error code. /returns

public int BackupDatabaseToFile(string filename)

        {

  IntPtr backup = new IntPtr();

  IntPtr destDB = new IntPtr();

  IntPtr memDB = new IntPtr();

  int returnCode;

  var encoding = new System.Text.UTF8Encoding();



  byte[] destName = encoding.GetBytes(filename);



  //get the handle to the memory database

  IDbConnection iconn = ConnectionProvider.GetConnection();

  SQLiteConnection conn = (SQLiteConnection)iconn;

  SQLite3 database = conn.Sql as SQLite3;

  memDB = database.Sql;



  //the rest is similar to the SQLite C examples

  //open the file for writing

  returnCode = sqlite3_open(destName, out destDB);

  if (returnCode == 0)

  {

   //begin the backup

   backup = sqlite3_backup_init(destDB, encoding.GetBytes("main"), memDB,

                                           encoding.GetBytes("main"));

   if (backup != IntPtr.Zero)

   {

    sqlite3_backup_step(backup, -1);

    sqlite3_backup_finish(backup);

   }

   returnCode = sqlite3_errcode(destDB);

  }

  //close the file, but not the memory database

  sqlite3_close(destDB);

  return returnCode;

}

Note: Use this at your own risk. There is a reason I'm not submitting this as a patch - it's not consistent with the framework and may be insecure.