DbCRUD.SqlServer 1.0.0

There is a newer version of this package available.
See the version list below for details.

dotnet add package DbCRUD.SqlServer --version 1.0.0

NuGet\Install-Package DbCRUD.SqlServer -Version 1.0.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.SqlServer" Version="1.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add DbCRUD.SqlServer --version 1.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: DbCRUD.SqlServer, 1.0.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.SqlServer as a Cake Addin
#addin nuget:?package=DbCRUD.SqlServer&version=1.0.0

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

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

安装

Install-Package DbCRUD.SqlServer 安装包

数据库连接及初始化

 //数据库连接
 IDbCRUD testdb = new SqlServerCRUD(@"Data Source=xxx;Initial Catalog=xxx;User ID=sa;Password=xxx;Encrypt=True;TrustServerCertificate=True;");

插入数据

 //获取最大ID,用于ID编号
            int dbcount = testdb.TableExists(tb_custormer) ? testdb?.Count(tb_custormer) ?? 0 : 0;
            //**同步插入对象数据
            var customer = new CrudTestModel
            {
                ID = dbcount + 1, //如果要使用DB自身编号功能，ID不要赋值即可
                Name = "对象插入",
                Phones = new string[] { "80000", "90000" },
                IsActive = true,
            };
            var result = testdb.Insert(tb_custormer, customer);

alternate text is missing from this package README image

 //**同步插入字典数据
           var dic1 = new Dictionary<string, object>
           {
               //{ "ID", 1 },//***如果不指定ID,插入时会自动编一个int的唯一ID
               { "Name", "mysql自动编号插入" },
               { "Qty", 19},
               { "DDate", DateTime.Now }
           };
           var result11 = testdb.Insert(autoIDData, dic1);
      //**批量插入列表
           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

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

//** 更新或插入数据
           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,pagenumber:10);
   //分页查找的数据,返回DataTable
   var dt = testdb.GetPagingData(dictable, "Qty>10", project: "*", pageindex: 1, pagenumber: 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.

.NETStandard 2.0
- DbCRUD (>= 1.2.0)
- Microsoft.Data.SqlClient (>= 5.1.1)
- Newtonsoft.Json (>= 13.0.3)
.NETStandard 2.1
- DbCRUD (>= 1.2.0)
- Microsoft.Data.SqlClient (>= 5.1.1)
- Newtonsoft.Json (>= 13.0.3)
net6.0
- DbCRUD (>= 1.2.0)
- Microsoft.Data.SqlClient (>= 5.1.1)
- Newtonsoft.Json (>= 13.0.3)
net7.0
- DbCRUD (>= 1.2.0)
- Microsoft.Data.SqlClient (>= 5.1.1)
- Newtonsoft.Json (>= 13.0.3)

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.3.1	46	6/24/2024
1.3.0	98	4/8/2024
1.2.10	78	4/6/2024
1.2.9	90	3/22/2024
1.2.8	90	3/21/2024
1.2.6	129	7/27/2023
1.2.5	114	6/26/2023
1.2.4	122	6/18/2023
1.2.3	113	6/13/2023
1.2.2	115	6/11/2023
1.2.1	111	6/10/2023
1.2.0	105	6/8/2023
1.1.0	105	6/6/2023
1.0.0	107	6/2/2023

增加简单的增删改查

DbCRUD.SqlServer 1.0.0

安装

数据库连接及初始化

插入数据

更新数据

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

查询数据

删除数据

.NETStandard 2.0

.NETStandard 2.1

net6.0

net7.0

NuGet packages

GitHub repositories