in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

LINQ Status Update?

Last post 02-13-2008 8:29 AM by mcnamara. 22 replies.
Page 1 of 2 (23 items) 1 2 Next >
Sort Posts: Previous Next
  • 08-12-2007 4:27 PM

    LINQ Status Update?

    Hi,

    First of all, like others, just wanted to say thanks for the time and effort you've put into this SQLite provider. Really awesome and I've used it a tonne.

    I'm quite curious about the status and/or timeframe for usable LINQ support. My content management system natively supports SQLite for those who don't want to run a heavy duty database or can't afford it. (http://code.google.com/p/sprocketcms) I'm really keen to move it towards .Net 3.5 (Specifically, LINQ) but the one thing that stops me is when I think to myself "ah, System.Data.SQLite doesn't support it properly yet" and then I put it off in favour of other more immediately productive tasks.

    If you have any idea what we should expect regarding .Net 3.5, please let us know!

    cheers,
    Nathan
     

    Filed under:
  • 08-21-2007 8:04 AM In reply to

    Re: LINQ Status Update?

    It's being worked on.  I'm in communication with the ADO.NET team at Microsoft and am basically just waiting on the next release of the LINQ stuff to coincide with the Beta2 release of VS2008.

    Robert

     

  • 08-21-2007 5:31 PM In reply to

    Re: LINQ Status Update?

    I'm confused; VS 2008 beta 2 is already released.  Is there extra LINQ stuff that will be released later?

    Good to hear you're on it; I think now with the release of beta 2 a lot more people are going to be interested.

    James

  • 08-21-2007 7:42 PM In reply to

    Re: LINQ Status Update?

    The ADO.NET Entity Framework upon which the 3.5 ADO.NET providers are built is not sync'd to the VS2008 release.  Read more on the timing of the releases on the ADO.NET Team Blog.

    Robert

     

  • 09-24-2007 12:52 PM In reply to

    Re: LINQ Status Update?

    Just checking in again, wondering if there's any news on the LINQ front.  I'm psyched about using LINQ with SQLite, it's going to be awesome.  Is there any way I can help out with updating the provider?

    Filed under:
  • 09-24-2007 9:13 PM In reply to

    Re: LINQ Status Update?

    I just haven't had the time to work on the provider much this month.  I've got a .45 version just about ready for release to fix a few bugs, but then SQLite 3.5.0 is going to be coming out soon and require some major rework.

    Then there's my day job...  :)

    I still have every intention of supporting LINQ well before VS2008 hits the shelves.  There's quite a few VS integration changes necessary for it too, so that'll be even more fun.  bleh.

    Robert

     

  • 11-02-2007 11:06 AM In reply to

    Re: LINQ Status Update?

     Hey, its been about a month, is this any closer to reality? I've hacked up a query-only provider here:

    http://kubasik.net/blog/2007/10/25/sqllite-linq-provider/

     But would love to see a real solution soon. I'm more than willing to help if its needed/wanted!

  • 12-04-2007 2:10 AM In reply to

    Re: LINQ Status Update?

     Hello all,

     I'm new on this forum and I would like to use SQLite with Linq, how development is going on this?

     Thanks,

     Ben.

    Filed under:
  • 12-04-2007 2:28 AM In reply to

    Re: LINQ Status Update?

     I still haven't heard anything reguarding a full DataContext (think bi-directional support like the official Linq to Sql) but I have a query parser available here:

    http://kubasik.net/blog/2007/10/25/sqllite-linq-provider/

     and am working on porting my sqlite specific stuff to integrate with this project which aimes to provide open source linq providers for most major databases. 

    http://code.google.com/p/dblinq2007/

    Right now I have a lot of work already in place, the issue isn't so much the provider as much as generating the mappings. If someone could help me write a sqlmetal tool for sqlite, I could release some open source (uber alpha) full Linq to Sqlite support, but otherwise, I'll be a while, although maybe this project will produce something soon. =/

  • 12-04-2007 2:37 PM In reply to

    Re: LINQ Status Update?

    What about decompiling sqlmetal using Reflector and using its source to write new one for sqlite? 

  • 12-05-2007 12:28 AM In reply to

    Re: LINQ Status Update?

    There are 2 main issues with that approach

    1) SQlite and MS Sql both conform to some quasi-sql-like-query-form, however, their metadata/administrative structures are radically different, getting table mappings and key restraints etc. and are handled differently in the end. As a result, since about 70% of the sqlmetal logic is just extracting that information about a database, there's really not much to be had.

     2) This code is to be open for anyone to use, preferably open-source (although there was no license on the tutorial I followed for the first parts of it, so hypothetically someone could make a fuss, but it would probably die/ who posts a tutorial but presses copylaws on the code). However, this same generous nature most definatly does not apply to decompiling/reflecting the Microsoft libraries, they come down fast and hard, and there is a good chance if the code was ever incorperated into a larger project, that Microsoft migth try to shut down both of them. 

     

    =/ I know it kinda sucks, but the main issue is I rarley use SQlite outside of the most simple capacities, and as a result, I'm not familiar with how constraints etc. are handled (I think SQLite ignores alot of them..) but yeah, if somone who really knows their sqlite wants to help, all I need is a valid mapping tool, and I can finish a buggy implementation.  

  • 12-07-2007 9:40 AM In reply to

    Re: LINQ Status Update?

     Is the source for the Linq provider in the repository yet?  If not, could you put it in?

  • 12-07-2007 11:32 AM In reply to

    Re: LINQ Status Update?

    What repository? Where? The only source for my provider is a tarball on my blog. =/ If you want to contribute I can host it somewhere public, is bzr cool? or should I use SVN?
  • 12-07-2007 2:25 PM In reply to

    Re: LINQ Status Update?

    sorry I meant @ robert.  I had noticed a folder labled linq in the most recent source distro but didnt get into what it did.

    I grabbed the tarball from your blog. it looks nice.  Any references on generating the update parts?

     

  • 12-07-2007 2:57 PM In reply to

    Re: LINQ Status Update?

    I'm not familiar with bzr as source control.   

Page 1 of 2 (23 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems