System.Data.SQLite

 I lovewhat y'all have provided to-date. I was wondeing when the next version of System.Data.SQLite might be coming, and would it support the latest version of SQLite's support for real foreign key constraints?

 

Thanks.

 

It's coming soon, I promise.  There've been a few iterations of the engine at sqlite.org and I've been too busy to keep up the last couple months.  Things will quiet down for me in a couple weeks and I'll be able to get caught up with the provider.

 

 Thanks a lot for your hard work!!!

I am also looking forward to the new release.

Hi Robert, Proper foreign key support is something l'd like to take advantage of with sqlite version >= 3.6.19. Do you have any idea when you'll be releasing the new provider? Great project btw. Thanks -Dano

Hi Robert!

I'd like to know if the new version will be released soon or not.

I have to make decision regarding to the tool we'll use for the next project, so it's important for me to have information about new version of this project.

Thank you very much.

 

I should have it done by the end of the month -- along with support for the SQLite C# project.

 That's good news.  Anything I can help with or compatibility issues we need to resolve?

 

Noah Hart

When I looked, it appeared that the only thing left in your C# implementation that used DllImport was the LockFile function?  I think if you or I were able to come up with some code that didn't use that DllImport, you'd have a fully managed engine capable of running in medium trust.

There is existing code in SQLite which was implemented for CE and other machines that dont support file locking.  I've considered implementing that instead of the basic windows locking code.  The only problem is there are some conflicts if a database is opened with the CE locking scheme and another application opens the same database with file locking.

My guess is that this would never happen, and the benefits far outweigh the theoretical problems

:)

In the worst case, they could create a "issue"in the C#-SQLite project ...

 Another heads up ... 

 I am just about tho change the code base with the following changes

namespace from

Community.Data.SQLite

to

Community.CsharpSqlite

public class from

csSqlite

to 

Sqlite3

 

I wrote the core SQLite file locking code for Windows CE, so I'm pretty familiar with it.  FileStream.Lock may be the route to take instead.  The CE locking code doesn't work at all over a network share and wasn't designed for that.

 

 Would you be willing to supply replacement code for C#-SQLite? 

If it supports both windows and silverlight that would be great!

 

Noah

Robert, changes we've sent to use C# SQLite in Silverlight clearly showing that Silverlight doesn't have FileStream.Lock. So for Silverlight at least exclusive lock on file should be used.

Any news about new version release date? :)

Hi Robert, Do you have any new ETA? We would really love to see foreign keys improvement asap. I have tried downloading source from SF but it appears the only version I can get my hands on is 064. We are so desperate for foreign keys support that we are willing to fix the source ourselves if that's what it takes. Btw, you have done absolutely amazing work!