How to install SQLite to be part of a C # project?

3

I'm creating a desktop application in C # of registry that will use database. Which database to use?

I was advised to use SQLite , but I'm not fully understanding how to use it.

  • What version of SQLite should I download, could you help me with the link ?
  • Which manager should I use to create the bank and the tables? Does Visual Studio have this tool?
  • How to integrate the bank to be part of the project, so that in the installation it is installed together?
  • asked by anonymous 18.12.2015 / 20:18

    3 answers

    5
      

    What version of SQLite should I download, could you help me with the link?

    The latest NuGet package . This version works for 32 and 64 bits.

      

    Which manager should I use to create the bank and tables? Does Visual Studio have this tool?

    Tools for Visual Studio are here .

      

    How to integrate the bank to be part of the project, so that in the installation it is installed together?

    The SQLite database is a file, so just put this file in the project directories (usually the App_Data directory).

    In addition, point your connection string to the file. The ideal is by configuration, but can be by code as well.

    new SQLiteConnection("Data Source=C:\Diretorio\banco.sqlite;Version=3;");
    
        
    18.12.2015 / 20:22
    3

    The question is broad, generic, I will answer it this way. If you need details, ask more specific questions with details of what you need.

    You should download the newest version. But have a lot of option, have to see what you need. The download can be done at official page . It has to match the .Net you are using and which operating system it will run. You'd better get Nuget . The more recommended . But others may be needed as you develop and want to improve the experience.

    What's closest to helping with Visual Studio is this here . People often use external tools much better .

    The database file is a file like any other, it does not need installation, nothing. Just copy it along with the rest of the application.

        
    18.12.2015 / 20:28
    0

    Hello, I made an application based on examples From This Site

    If you want the ID field to be autoincrement, do not build the file with the .sqlite extension build with the .db extension

        
    22.02.2018 / 15:22