高性能数据访问操作示例+Z.Dapper.Plus+免费

共213个文件

dll：73个

xml：56个

_：22个

需积分: 5 39 浏览量 2022-04-25 23:55:33 上传评论收藏 8.28MB 7Z 举报

在IT行业中，高效的数据访问是系统性能的关键因素之一。Z.Dapper.Plus是针对.NET平台的一个高性能、轻量级的数据访问扩展库，它基于Dapper，增强了批量操作、缓存和事务管理等功能，使得数据库交互更为便捷且高效。本示例主要展示了如何使用Z.Dapper.Plus免费版进行数据访问操作。 Dapper本身是一个轻量级的ORM（对象关系映射）工具，它不提供复杂的对象映射或主动实体管理，而是专注于SQL查询的执行，具有良好的性能表现。Z.Dapper.Plus在其基础上进行了扩展，提供了更丰富的功能，如批量插入、更新、删除以及查询，这些操作无需编写繁琐的SQL语句，大大提高了开发效率。在C#中使用Z.Dapper.Plus，你需要首先安装Z.Dapper.Plus的NuGet包。然后，你可以通过以下步骤来实现高性能的数据访问： 1. **初始化连接**：创建一个SqlConnection实例，这是与SQL Server通信的基础。例如： ```csharp var connectionString = "your_connection_string"; using (var connection = new SqlConnection(connectionString)) { // 其他操作 } ``` 2. **注册实体**：Z.Dapper.Plus需要知道你的实体类，以便正确地映射到数据库表。你可以使用`EntityConfig<T>`来配置实体，如下所示： ```csharp EntityConfig<Person>.Setup() .OnDelete(p => p.SetSql("DELETE FROM People WHERE Id = @Id")) .OnInsert(p => p.UseIdentityId()); ``` 3. **批量操作**：Z.Dapper.Plus的强项在于批量操作，例如批量插入： ```csharp List<Person> people = GetPeopleList(); connection.BulkInsert(people); ``` 这将一次性插入所有人员，比逐个插入更高效。 4. **查询**：虽然Dapper已经支持简单的查询，但Z.Dapper.Plus提供了更方便的查询方法，如： ```csharp var result = connection.BulkSelect<Person>(peopleList, x => x.Id > 10); ``` 这将返回`peopleList`中Id大于10的所有人员。 5. **更新和删除**：Z.Dapper.Plus同样支持批量更新和删除，只需提供相应的条件即可： ```csharp connection.BulkUpdate(peopleList, p => p.Age > 30); connection.BulkDelete<Person>(p => p.Age < 18); ``` 6. **事务处理**：对于需要确保原子性的操作，可以利用Z.Dapper.Plus的事务功能： ```csharp using (var transaction = connection.BeginTransaction()) { // 执行一系列操作 connection.BulkInsert(people1); connection.BulkUpdate(people2); if (allGood) { transaction.Commit(); } else { transaction.Rollback(); } } ``` 在提供的Test.Z.Dapper.Plus压缩包中，可能包含了示例代码或者测试用例，用于演示如何实际应用上述操作。通过学习和理解这些示例，开发者可以更好地掌握Z.Dapper.Plus的使用方法，从而在项目中实现高效的数据库访问。 Z.Dapper.Plus是C#开发者进行高性能数据访问的一个优秀选择，尤其适合需要大量数据操作的场景。其简洁的API设计和强大的功能集使其在.NET社区中受到广泛欢迎。通过熟练掌握Z.Dapper.Plus，开发者可以提高代码质量，减少维护成本，同时提升系统的运行效率。

资源详情

资源评论

资源推荐

收起资源包目录

高性能数据访问操作示例+Z.Dapper.Plus+免费（213个子文件）

_._ 0B

Test.Z.Dapper.Plus.csproj.AssemblyReference.cache 25KB

DesignTimeResolveAssemblyReferencesInput.cache 8KB

Test.Z.Dapper.Plus.csproj.CoreCompileInputs.cache 42B

Test.Z.Dapper.Plus.csproj.SuggestedBindingRedirects.cache 0B

packages.config 867B

Test.Z.Dapper.Plus.exe.config 548B

app.config 548B

Test.Z.Dapper.Plus.csproj.CopyComplete 0B

Program.cs 1KB

AssemblyInfo.cs 1KB

.NETFramework,Version=v4.8.AssemblyAttributes.cs 210B

.NETFramework,Version=v4.0.AssemblyAttributes.cs 208B

Test.Z.Dapper.Plus.csproj 6KB

BouncyCastle.Crypto.dll 2.41MB

MySql.Data.dll 1.44MB

MySql.Data.dll 1.36MB

Z.Dapper.Plus.dll 712KB

Google.Protobuf.dll 381KB

Google.Protobuf.dll 380KB

System.Numerics.Vectors.dll 160KB

System.Numerics.Vectors.dll 157KB

System.Memory.dll 138KB

System.Memory.dll 134KB

System.Numerics.Vectors.dll 113KB

K4os.Compression.LZ4.dll 59KB

Ubiety.Dns.Core.dll 55KB

System.Numerics.Vectors.dll 37KB

K4os.Compression.LZ4.Streams.dll 37KB

K4os.Compression.LZ4.Streams.dll 33KB

K4os.Compression.LZ4.Streams.dll 32KB

System.Numerics.Vectors.dll 29KB

ZstdNet.dll 28KB

System.Buffers.dll 21KB

System.Buffers.dll 20KB

System.Runtime.CompilerServices.Unsafe.dll 19KB

System.Runtime.CompilerServices.Unsafe.dll 17KB

System.Runtime.CompilerServices.Unsafe.dll 16KB

共 213 条

# The Bouncy Castle Crypto Package For C Sharp The Bouncy Castle Crypto package is a C\# implementation of cryptographic algorithms and protocols, it was developed by the Legion of the Bouncy Castle, a registered Australian Charity, with a little help! The Legion, and the latest goings on with this package, can be found at [http://www.bouncycastle.org](http://www.bouncycastle.org). In addition to providing basic cryptography algorithms, the package also provides support for CMS, TSP, X.509 certificate generation and a variety of other standards such as OpenPGP. The Legion also gratefully acknowledges the contributions made to this package by others (see [here](http://www.bouncycastle.org/csharp/contributors.html) for the current list). If you would like to contribute to our efforts please feel free to get in touch with us or visit our [donations page](https://www.bouncycastle.org/donate), sponsor some specific work, or purchase a support contract through [Crypto Workshop](http://www.cryptoworkshop.com). Except where otherwise stated, this software is distributed under a license based on the MIT X Consortium license. To view the license, [see here](http://www.bouncycastle.org/licence.html). The OpenPGP library also includes a modified BZIP2 library which is licensed under the [Apache Software License, Version 2.0](http://www.apache.org/licenses/). **Note**: this source tree is not the FIPS version of the APIs - if you are interested in our FIPS version please contact us directly at [office@bouncycastle.org](mailto:office@bouncycastle.org). ## Mailing Lists For those who are interested, there are 2 mailing lists for participation in this project. To subscribe use the links below and include the word subscribe in the message body. (To unsubscribe, replace **subscribe** with **unsubscribe** in the message body) * [announce-crypto-csharp-request@bouncycastle.org](mailto:announce-crypto-csharp-request@bouncycastle.org) This mailing list is for new release announcements only, general subscribers cannot post to it. * [dev-crypto-csharp-request@bouncycastle.org](mailto:dev-crypto-csharp-request@bouncycastle.org) This mailing list is for discussion of development of the package. This includes bugs, comments, requests for enhancements, questions about use or operation. **NOTE:**You need to be subscribed to send mail to the above mailing list. ## Feedback If you want to provide feedback directly to the members of **The Legion** then please use [feedback-crypto@bouncycastle.org](mailto:feedback-crypto@bouncycastle.org), if you want to help this project survive please consider [donating](https://www.bouncycastle.org/donate). For bug reporting/requests you can report issues here on github, via feedback-crypto if required, and we also have a [Jira issue tracker](http://www.bouncycastle.org/jira). We will accept pull requests based on this repository as well. ## Finally Enjoy!