This page shows how to interact with an SQLite database in C# applications using ADO.NET.
Section 1. Getting Started
This section shows you how to connect to an SQLite database file and create a new table.
- Connecting to an SQLite database – show you how to connect to a SQLite database file using C#.
- Creating a table – learn to create a table in SQLite database file from a C# program.
Section 2. Performing Database Operations
This section covers the common database operations including inserting data, updating, data, deleting data, and retrieving data. It also shows you how to import data from a CSV file into a table in an SQLite database.
- Inserting data into a table – guide you on inserting one or more rows into a table in SQLite database from a C# program.
- Updating data – learn how to update data in a table in an SQLite database from a C# program using ADO.NET
- Deleting data – discover how to delete data from a table in an SQLite database from a C# program.
- Import CSV file into a table – show you how to read data from a CSV file and load it into a table in an SQLite database in C#.
- Selecting data – show you how to retrieve one or more rows from a table in an SQLite database from a C# program using ADO.NET.
Section 3. Transactions
This section guides you on how to perform a database transaction via C# ADO.NET.
- Transaction – learn how to perform a database transaction in SQLite database using C#.
Was this tutorial helpful ?
