DbCRUD 1.6.1

.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. 
dotnet add package DbCRUD --version 1.6.1                

                    
                

            
NuGet\Install-Package DbCRUD -Version 1.6.1
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" Version="1.6.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DbCRUD --version 1.6.1                

                    
                

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

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

Package Description

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 was computed. 
.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 (6)

Showing the top 5 NuGet packages that depend on DbCRUD:

Package Downloads
DbCRUD.LiteDB

这是一个LiteDB的二次封装，可以很方便的增删改查，无需提前建库，建表，安装就能快速上手使用。 用惯了SQL的开发人员，一下使用NOSQL,可能不太适应，所以本库支持SQL语句增删改查，到达SQL语句对LiteDB进行数据操作。 详细使用请见包自述文件 或https://www.cnblogs.com/zzwen/p/17351036.html This is a secondary package of LiteDB, can be very convenient to add, delete, modify and check, no need to build libraries in advance, build tables, installation can quickly start to use. Developers who are used to SQL may not be comfortable with NOSQL, so this library supports SQL statements to add, delete, modify and check, arrive at SQL statements for data operations on LiteDB See the package readme for detailed usage Key-Value操作，常用于配置信息 string key = "test"; var v = DateTime.Now; //保存 var result = testdb.SaveKeyValue(key, v); //判断是否存在 bool isExists= testdb.KeyValueExists(key) //获取 var getv = testdb.GetKeyValue<DateTime>(key); //删除 bool ok= testdb.DelKeyValue(key)
DbCRUD.MongoDB

此类库非常简单方便对MongoDB进行增删改查。 1. 支持类SQL语句的CRUD -- 查询 时间范围："DDATE>='2023-06-05 09:12:24' and DDATE<='2023-06-05 10:00:00'" IN:Qty in(200,300) Like:"Name like'%odb%'" 正则表达式:"Name reg'^Batch'" sql语句: string sqlcmd = $"select !_id from {dictable} where Name='Batch insert'"; var sqldata = testdb.Find<Dictionary<string, object>>(sqlcmd); 2. 增加增删改数据回调事件，可以订阅此事件进行二次加工处理,实现类似触发器功能。 3. 支持根据查询条件自动创建索引 4. 支持自动转本地时间 5. 支持key-value类设置数据保存 6. 替换更新可指定保持列序 7. 可开启生成表列元信息记录，可获取数据集中的字段信息 8. 增加查询调用信息记录，并统计查询数量>100pcs或查询耗时>100ms的次数，监控查询调用情况。 9. 自动创建库，数据集 10. [NEW]增加不区分查询和添加更新数据，不再有大小写困扰。 ** 详情请见类库自述文件
DbCRUD.Mysql

这是操作MySQL简单的增删改查库。 1. 自动建库，建表，建字段，省去建表精力。 2. 支持对象，Json数据保存，实现像NOSQL一样的复杂数据增删改查。 详细使用请见包自述文件 # Key-Value操作，常用于配置信息 string key = "test"; var v = DateTime.Now; //保存 var result = testdb.SaveKeyValue(key, v); //判断是否存在 bool isExists= testdb.KeyValueExists(key) //获取 var getv = testdb.GetKeyValue<DateTime>(key); //删除 bool ok= testdb.DelKeyValue(key)
DbCRUD.Sqlite

这是操作SqLite简单的增删改查库。 1. 自动建库，建表，建字段，省去建表精力。 2. 支持对象，Json数据保存，实现像NOSQL一样的复杂 详细使用请见包自述文件 This is a simple addition, deletion and modification library for operating SqLite. 1. Automatic library building, table building, field building, save the energy of table building. 2. Support object, Json data storage, as complex as NOSQL See the package readme for detailed usage
DbCRUD.SqlServer

这是操作SQL SERVER简单的增删改查库。 1. 自动建库，建表，建字段，省去建表精力。 2. 支持对象，Json数据保存，实现像NOSQL一样的复杂数据增删改查。 详细使用请见包自述文件 This is a simple addition, deletion and modification library for operating SqLite. 1. Automatic library building, table building, field building, save the energy of table building. 2. Support object, Json data storage, as complex as NOSQL See the package readme for detailed usage

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.6.1 762 6/24/2024
1.6.0 742 4/8/2024
1.5.2 351 4/6/2024
1.5.1 481 3/22/2024
1.5.0 362 3/21/2024
1.4.0 2,973 8/27/2023
1.3.9 864 8/4/2023
1.3.8 839 7/31/2023
1.3.7 1,911 7/23/2023
1.3.6 944 7/19/2023
1.3.5 842 7/14/2023
1.3.4 1,769 7/6/2023
1.3.3 942 6/26/2023
1.3.2 960 6/18/2023
1.3.1 1,007 6/13/2023
1.3.0 4,327 6/11/2023

优化json格式判断