一、C#以只读的方式读取SQLlite数据库文件的方法
1、使用 SQLite.NET
需要安装 SQLite.NET NuGet 包,然后按照以下步骤读取 SQLite 数据库文件:
using System.Data.SQLite;string connectionString = "Data Source=path_to_your_database_file";using (SQLiteConnection connection = new SQLiteConnection(connectionString)){connection.Open();// 读取数据using (SQLiteCommand command = new SQLiteCommand("SELECT * FROM your_table", connection))using (SQLiteDataReader reader = command.ExecuteReader()){ while (reader.Read()) { // 处理每一行的数据 string column1 = reader.GetString(0); int column2 = reader.GetInt32(1); // ... }}
2、使用 Entity Framework Core
需要安装 Microsoft.EntityFrameworkCore.Sqlite NuGet 包,然后按照以下步骤读取 SQLite 数据库文件:
创建一个 DbContext 类来表示数据库上下文:
using Microsoft.EntityFrameworkCore;public class YourDbContext : DbContext{public DbSet YourEntities { get; set; }protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder){ string connectionString = "Data Source=path_to_your_database_file"; optionsBuilder.UseSqlite(connectionString);}
然后,在你的代码中使用 DbContext 来读取数据:
using (var context = new YourDbContext()){// 读取数据var entities = context.YourEntities.ToList();foreach (var entity in entities){ // 处理每一行的数据 string column1 = entity.Column1; int column2 = entity.Column2; // ...}