Xtensive.Orm.BulkOperations
7.1.2
See the version list below for details.
dotnet add package Xtensive.Orm.BulkOperations --version 7.1.2
NuGet\Install-Package Xtensive.Orm.BulkOperations -Version 7.1.2
<PackageReference Include="Xtensive.Orm.BulkOperations" Version="7.1.2" />
paket add Xtensive.Orm.BulkOperations --version 7.1.2
#r "nuget: Xtensive.Orm.BulkOperations, 7.1.2"
// Install Xtensive.Orm.BulkOperations as a Cake Addin #addin nuget:?package=Xtensive.Orm.BulkOperations&version=7.1.2 // Install Xtensive.Orm.BulkOperations as a Cake Tool #tool nuget:?package=Xtensive.Orm.BulkOperations&version=7.1.2
Xtensive.Orm.BulkOperations
Summary
The extension provides a set of IQueryable extension methods that are translated to server-side UPDATE or DELETE commands.
Prerequisites
DataObjects.Net 7.1.x (http://dataobjects.net)
Examples of usage
Example #1. Update primitive property with a constant value:
session.Query.All<Bar>()
.Where(a => a.Id == 1)
.Set(a => a.Count, 2)
Update();
Example #2 Updating persistent property with expression, computed on server:
session.Query.All<Bar>()
.Where(a => a.Id==1)
.Set(a => a.Count, a => a.Description.Length)
.Update();
Example #3. Setting a reference to an entity that is already loaded into current Session
// Emulating entity loading
var bar = session.Query.Single<Bar>(1);
session.Query.All<Foo>()
.Where(a => a.Id == 2)
.Set(a => a.Bar, bar)
.Update();
Example #4. Setting a reference to an entity that is not loaded into Session, 1st way
session.Query.All<Foo>()
.Where(a => a.Id == 1)
.Set(a => a.Bar, a => Query.Single<Bar>(1))
.Update();
Example #5. Setting a reference to an entity that is not loaded into Session, 2nd way
session.Query.All<Foo>()
.Where(a => a.Id == 1)
.Set(a => a.Bar, a => Query.All<Bar>().Single(b => b.Name == "test"))
.Update();
Example #6. Constructing update expressions of the fly
bool condition = CheckCondition();
var query = session.Query.All()<Bar>
.Where(a => a.Id == 1)
.Set(a => a.Count, 2);
if(condition)
query = query.Set(a => a.Name, a => a.Name + "test");
query.Update();
Example #7. Updating lots of properties at once
session.Query.All<Bar>()
.Where(a => a.Id == 1)
Update(
a => new Bar(null) { Count = 2, Name = a.Name + "test", /*dozens of other properties...*/ });
Example #8. Deleting entities
session.Query.All<Foo>()
.Where(a => a.Id == 1)
.Delete();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 is compatible. 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 was computed. 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. |
-
net5.0
- Xtensive.Orm (>= 7.1.2)
-
net6.0
- Xtensive.Orm (>= 7.1.2)
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 |
---|---|---|
7.2.0-Beta-1 | 125 | 12/28/2023 |
7.1.2 | 231 | 10/18/2024 |
7.1.1 | 10,885 | 11/14/2023 |
7.1.0 | 417 | 4/12/2023 |
7.1.0-RC | 157 | 3/9/2023 |
7.1.0-Beta-2 | 178 | 12/19/2022 |
7.1.0-Beta-1 | 198 | 7/4/2022 |
7.0.5 | 98 | 6/3/2024 |
7.0.4 | 155 | 11/12/2023 |
7.0.3 | 1,515 | 3/21/2022 |
7.0.2 | 560 | 2/8/2022 |
7.0.1 | 443 | 10/29/2021 |
7.0.0 | 463 | 6/2/2021 |
6.0.13 | 166 | 4/4/2024 |
6.0.12 | 15,202 | 11/10/2023 |
6.0.11 | 755 | 1/12/2023 |
6.0.10 | 758 | 4/29/2022 |
6.0.9 | 635 | 2/2/2022 |
6.0.8 | 504 | 10/28/2021 |
6.0.7 | 50,886 | 8/27/2021 |
6.0.6 | 504 | 5/24/2021 |
6.0.5 | 722 | 3/9/2021 |
6.0.4 | 12,390 | 12/22/2020 |
6.0.3 | 599 | 9/29/2020 |
6.0.0 | 1,256 | 1/28/2020 |
5.1.0-Beta-1 | 1,312 | 1/30/2015 |
5.0.24 | 506 | 4/27/2021 |
5.0.23 | 476 | 2/4/2021 |
5.0.22 | 645 | 11/18/2020 |
5.0.21 | 595 | 11/6/2020 |
5.0.20 | 764 | 12/25/2019 |
5.0.19 | 18,218 | 5/30/2019 |
5.0.19-Beta-2 | 736 | 4/16/2019 |
5.0.19-Beta-1 | 621 | 12/29/2018 |
5.0.18 | 3,803 | 9/28/2018 |
5.0.18-Beta-3 | 795 | 7/2/2018 |
5.0.18-Beta-2 | 844 | 6/6/2018 |
5.0.18-Beta-1 | 803 | 4/24/2018 |
5.0.17 | 1,490 | 2/27/2018 |
5.0.17-Beta-3 | 910 | 2/12/2018 |
5.0.17-Beta-2 | 882 | 1/12/2018 |
5.0.17-Beta-1 | 975 | 12/28/2017 |
5.0.16 | 1,172 | 12/1/2017 |
5.0.16-Beta-1 | 828 | 9/27/2017 |
5.0.15 | 1,205 | 8/1/2017 |
5.0.14 | 1,162 | 6/19/2017 |
5.0.13 | 1,305 | 3/22/2017 |
5.0.12 | 1,154 | 2/14/2017 |
5.0.11 | 1,077 | 1/25/2017 |
5.0.11-RC2 | 836 | 12/16/2016 |
5.0.11-RC | 1,160 | 9/20/2016 |
5.0.10 | 1,101 | 8/5/2016 |
5.0.10-RC | 831 | 6/30/2016 |
5.0.9 | 1,398 | 3/3/2016 |
5.0.8 | 1,234 | 2/15/2016 |
5.0.7 | 1,239 | 1/27/2016 |
5.0.7-RC2 | 841 | 12/8/2015 |
5.0.7-RC | 897 | 9/10/2015 |
5.0.6 | 1,261 | 7/3/2015 |
5.0.5 | 1,436 | 4/23/2015 |
5.0.4 | 1,255 | 3/19/2015 |
5.0.4-RC | 1,193 | 2/25/2015 |
5.0.3 | 1,905 | 10/31/2014 |
5.0.2 | 1,258 | 9/11/2014 |
5.0.0 | 1,269 | 8/15/2014 |
5.0.0-RC2 | 938 | 8/1/2014 |
5.0.0-RC | 952 | 7/21/2014 |
5.0.0-Beta-3 | 937 | 5/28/2014 |
5.0.0-Beta-2 | 1,012 | 2/28/2014 |
5.0.0-Beta-1 | 993 | 11/14/2013 |
4.6.9 | 1,212 | 7/3/2015 |
4.6.8 | 1,211 | 8/1/2014 |
4.6.7 | 1,282 | 6/23/2014 |
4.6.6 | 1,419 | 4/9/2014 |
4.6.5 | 1,289 | 1/7/2014 |
4.6.4 | 2,873 | 9/30/2013 |
4.6.3 | 2,086 | 2/4/2013 |
4.6.2 | 1,693 | 11/28/2012 |
4.6.0 | 1,508 | 10/11/2012 |
4.6.0-RC | 1,096 | 10/4/2012 |
4.5.8 | 1,227 | 9/30/2013 |
4.5.7 | 1,360 | 2/4/2013 |
4.5.6 | 1,478 | 11/28/2012 |
4.5.5 | 1,446 | 10/11/2012 |
4.5.5-RC | 1,135 | 10/4/2012 |
4.5.3 | 1,427 | 8/6/2012 |
4.5.2 | 1,500 | 5/10/2012 |
4.5.0 | 1,607 | 3/13/2012 |