System.Data.SQLite

Hi folks. 

Full-text searching would be very useful in our project. Was just wondering whether System.Data.SQLite enables us to use this functionality. Would this involve loading a module?

Using in-memory databases would be a lower priority, but I'd be interested to know whether it's possible.

Also, is this any different in the LINQ/vNext version? We will be using the LINQ version in our project.

Thanks.

Michael.
 

Try searching the forums. Here are a few results I thought would be most helpful... there are more.

Some full-text details: http://sqlite.phxsoftware.com/forums/p/801/3563.aspx#3563
In-Memory details: http://sqlite.phxsoftware.com/forums/p/151/2136.aspx

Thanks Nate. Those threads give me the information I was after.

Regarding the LINQ/vNext issue, am I right in thinking that the LINQ features basically sit on top of the ADO.NET 2.0 provider, and hence won't affect the full-text/in-memory features or the way they work?

Yes, LINQ sits on top of ADO.NET.

Thanks Robert.

And thank you for the .NET SQLite provider. SQLite is just what we need for our project, and it's great to have a proper ADO.NET 2.0 provider.

BTW, is it possible to use your released vNext SQLite provider with .NET Framework 3.5/VS2008 beta 2 and the latest Entity Framework stuff? I'm aware that it was built against the beta 1 stuff, but I was wondering whether it's still compatible.

I'm assuming that we'd have to write the mapping (EDMX/CSDL/MSL/SSDL) manually, and I'm currently trying to work out how to do that.

Thanks.