locked
Is SQLite-Net same as SQLite-WinRT

    Question

  • Hi,

    My VS 2012/VS2013 were not being able to display designer for past few days. Today, they are able to. I don't know if they got to with SQLite Api. This is the changed I notice:

    1) All my Previous SQLite-Net was gone. and it has been changed to SQLite for windows Runtime

    I am confused. Please help me for the below questions:

    a) Is SQLite-Net same as SQLite WinRT ?

    This is SQLite-Net

    var db =  new SQLite.SQLiteAsyncConnection(App.DBPath);
    var _customer = await  (from c in db.Table<Customer>()
                            where c.Id == customerId 
                            select c).FirstOrDefaultAsync();

    if (customer != null)

        var Id = _customer.Id;
        var Name = _customer.Name;
    }

    --- This is  SQLite-WinRT:

    using (var db = new SQLiteWinRTPhone.Database(
        ApplicationData.Current.LocalFolder, "demo.db"))
    {
        await db.OpenAsync();
        using (var stmt = await db.PrepareStatementAsync("SELECT name, age FROM people"))
        {
            while (await stmt.StepAsync())
            {
                var name = stmt.GetTextAt(0);
                var age = stmt.GetIntAt(1);
            }
        }
    }

    Thanks

    Sunday, July 20, 2014 2:47 AM

Answers

  • Hi FireDance,

    I don't think they are the same thing, at least from the name, one is capable with .NET, another one is specific for WinRT. And if you simply search for them on your search engine, should be able to know their homepage:

    SQLite-net: https://github.com/praeclarum/sqlite-net

    SQLite-WinRT: https://github.com/doo/SQLite3-WinRT or http://sqlwinrt.codeplex.com/

    Seems to be different thing. But they all announced that they are workable with Windows Store App.

    --James


    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

    Monday, July 21, 2014 7:35 AM
    Moderator
  • Hi Jamles Hez,

    The problem started when VS 2012 can not display the designer with no obvious reason and I am not sure how and when the SQLite Windows Runtime version changed is  required. This caused System show err msg that new version can not be located.

    The naming of SQLite WinRT and SQLite Windows Runtime cause confusion.

    1) SQLite-Net is not the same as SQLite WinRT ( which can mistakenly think it is a short form for SQLite Windows Runtime)

    Now it is working. I will report here if there is problem on SQLite.   I will answer on other thread regarding the Designer issue.

    Thanks

    Monday, July 21, 2014 1:23 PM

All replies

  • Hi FireDance,

    I don't think they are the same thing, at least from the name, one is capable with .NET, another one is specific for WinRT. And if you simply search for them on your search engine, should be able to know their homepage:

    SQLite-net: https://github.com/praeclarum/sqlite-net

    SQLite-WinRT: https://github.com/doo/SQLite3-WinRT or http://sqlwinrt.codeplex.com/

    Seems to be different thing. But they all announced that they are workable with Windows Store App.

    --James


    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

    Monday, July 21, 2014 7:35 AM
    Moderator
  • Hi Jamles Hez,

    The problem started when VS 2012 can not display the designer with no obvious reason and I am not sure how and when the SQLite Windows Runtime version changed is  required. This caused System show err msg that new version can not be located.

    The naming of SQLite WinRT and SQLite Windows Runtime cause confusion.

    1) SQLite-Net is not the same as SQLite WinRT ( which can mistakenly think it is a short form for SQLite Windows Runtime)

    Now it is working. I will report here if there is problem on SQLite.   I will answer on other thread regarding the Designer issue.

    Thanks

    Monday, July 21, 2014 1:23 PM