SQLite Datasource RRS feed

  • Question

  • Is there a way to get SQLite database when creating new datasource in Lightswitch html client project?
    I have .Net Framework Data Provider fro SQLite and System.Data.SQLite Database File when adding a new Data connection from Server explorer, but I cannot see that when try to connect LS.Server project to SQLite. I also installed System.Data.SQLite NuGet package in LS.Server project.

    Maybe some help?


    Tuesday, August 9, 2016 10:22 PM


  • Hi Bernard,

    To use SQLite, Click Attach to external Data Source and select Database in the displayed        dialog box. Click the Next button.

    Select SQLite in the Data source list, select dotConnect for SQLite        in the Data provider drop-down list, and click the Continue button.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Angie Xu Thursday, August 25, 2016 5:36 AM
    • Marked as answer by Angie Xu Thursday, August 25, 2016 5:36 AM
    Friday, August 12, 2016 7:40 AM