DbCRUD.Sqlite 1.2.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package DbCRUD.Sqlite --version 1.2.0
NuGet\Install-Package DbCRUD.Sqlite -Version 1.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="DbCRUD.Sqlite" Version="1.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DbCRUD.Sqlite --version 1.2.0
#r "nuget: DbCRUD.Sqlite, 1.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install DbCRUD.Sqlite as a Cake Addin
#addin nuget:?package=DbCRUD.Sqlite&version=1.2.0

// Install DbCRUD.Sqlite as a Cake Tool
#tool nuget:?package=DbCRUD.Sqlite&version=1.2.0

安装

Install-Package DbCRUD.Sqlite 安装包

数据库连接及初始化

 //数据库连接 Database connection
IDbCRUD testdb = new SqliteCRUD($@"Data Source=sqlitedb.db; Cache=Shared");

插入数据

int dbcount =testdb.TableExists(tb_custormer)? testdb?.Count(tb_custormer)??0: 0;
//**同步插入对象数据 Insert object data synchronously
var customer = new CrudTestModel
{
   ID = dbcount + 1, ////实体类，ID不赋值，默认根据数据类型自动整数编号，支持int,long,objectid
   Name = "对象插入",
   Phones = new string[] { "80000", "90000" },
   Dic = new Dictionary<string, object>
   {
       { "Name", "嵌套数据" },
       { "DDate", DateTime.Now }
   },
   IsActive = true,
};

alternate text is missing from this package README image

//**同步插入字典数据 Insert dictionary data synchronously
var dic1 = new Dictionary<string, object>
{
   //{ "ID", 1 },//***如果不指定ID,插入时会自动编一个int的唯一ID
   { "Name", "自动编号插入" },
   { "Qty", DateTime.Now.Minute},
   { "DDate", DateTime.Now }
};
var result11 = testdb.Insert(autoIDData, dic1);
//**批量插入列表 Batch insert
List<Dictionary<string, object>> listdata = new List<Dictionary<string, object>>();
int maxid = testdb.Max<int>(dictable);
for (int i = 0; i < 10; i++)
{
   maxid++;
   var dic2 = new Dictionary<string, object>
   {
       { "ID",maxid },
       { "Name", $"批量插入{i}" },
       { "Qty", 19+maxid},
       { "DDate", DateTime.Now }
   };
   listdata.Add(dic2);
}
var listResult= testdb.Insert(dictable, listdata);

更新数据

//更新前
var updatepre = testdb.Find<Dictionary<string, object>>(dictable, "ID=2")?.FirstOrDefault();
          
var updata = new Dictionary<string, object>
{
    { "Name", "更新指定字段数据" },
    { "Qty", 600}
};
var upresult = testdb.UpDate(dictable, updata, "ID=2");   //更新ID=2的数据
Assert.IsTrue(upresult.Stutas);
//更新后
var getupdata = testdb.Find<Dictionary<string, object>>(dictable, "ID=2")?.FirstOrDefault();
Assert.AreEqual(300, getupdata.GetValueOrDefault("Qty", 0));

alternate text is missing from this package README image

更新及插入数据（数据存在更新，不存在插入）

   //** 更新或插入数据 Update or insert data
   var dic1 = new Dictionary<string, object>
   {
       { "ID", 2 },
       { "Name", "插入或更新单条数据" },
       { "Qty", 200},
       { "DDate", DateTime.Now }
   };
   var result= testdb.Upsert(dictable, dic1);
   //** 批量插入或更新
   var dic3 = new Dictionary<string, object>
   {
       { "ID", 3 },
       { "Name", "批量插入或更新" },
       { "Qty", 300},
       { "DDATE", DateTime.Now }
   };
   List<Dictionary<string,object>> listdata=new List<Dictionary<string, object>> { dic3,dic1};
   var listresult = testdb.Upsert(dictable, listdata);

查询数据

   //查找id=2的数据
   var databyid = testdb.FindByID<Dictionary<string, object>>(dictable,2);
   //查找Qty>10的数据
   var wheredata = testdb.Find<Dictionary<string, object>>(dictable, "Qty>10");
   //sql语句查找的数据
   string sqlcmd = $"select * from {dictable}";
   var sqldata = testdb.Find<Dictionary<string, object>>(sqlcmd);
   //分页查找的数据
   var pagedata = testdb.GetPagingData<Dictionary<string, object>>(dictable, "Qty>10",pageindex:1,pagecount:10);

alternate text is missing from this package README image

删除数据

   //**删除_id=3的数据
   var result = testdb.Delete(dictable,3);
   //**删除qty<30的数据
   var wherresult = testdb.Delete(dictable, "Qty<30");
   //**使用sql语句删除_id=30的数据
   string sql = $"delete {dictable} where _id=30";
   var sqlresult = testdb.Delete(sql);
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.4.1 51 6/24/2024
1.4.0 92 4/8/2024
1.3.12 87 4/6/2024
1.3.11 89 3/22/2024
1.3.10 77 3/21/2024
1.3.9 158 8/4/2023
1.3.7 105 7/27/2023
1.3.6 124 7/6/2023
1.3.5 122 6/26/2023
1.3.4 125 6/18/2023
1.3.3 116 6/13/2023
1.3.2 111 6/11/2023
1.3.1 118 6/10/2023
1.3.0 117 6/8/2023
1.2.0 121 6/6/2023
1.1.0 122 5/27/2023

解决包依赖问题