This tutorial series shows you how to interact with an SQLite database in C# applications using ADO.NET.
Section 1. Getting Started
In this section, you will learn 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 common database operations including inserting, updating, deleting, and retrieving data. You’ll also learn to import data from a CSV file into a table in an SQLite database.
- Inserting data into a table – Show you how to insert one or more rows into a table in an SQLite database from a C# program.
- Updating data – Learn how to update data in an SQLite table using ADO.NET in C#.
- Deleting data – Discover how to delete data from a table in an SQLite database using 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 using ADO.NET in C#.
Section 3. Managing Transactions
This section guides you through performing database transactions using C# and ADO.NET.
- Transaction – Learn how to perform a database transaction in SQLite database using C#.
Was this tutorial helpful ?
