using System.Data;
using System.Data.SQLite;
namespace SQLite
{
class Program
{
static void Main(string[] args)
{
//数据源
DataTable dtData = new DataTable();
//创建数据库
SQLiteConnection con = new SQLiteConnection("Path\\Data.db");
con.Open();
//创建数据表
SQLiteCommand cmd = new SQLiteCommand("create table data ( id bigint, name varchar(10))", con);
cmd.ExecuteNonQuery();
//关闭同步
cmd.CommandText = "pragma synchronous = 0";
cmd.ExecuteNonQuery();
using (SQLiteTransaction tran = con.BeginTransaction())
{
try
{
using (SQLiteCommand command = new SQLiteCommand("Insert into data( id, name ) values( @id, @name )", con))
{
foreach
C# SQLite批量快速插入数据
最新推荐文章于 2024-05-12 17:38:20 发布