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 | 122 | 12/28/2023 |
7.1.2 | 155 | 10/18/2024 |
7.1.1 | 9,355 | 11/14/2023 |
7.1.0 | 411 | 4/12/2023 |
7.1.0-RC | 155 | 3/9/2023 |
7.1.0-Beta-2 | 176 | 12/19/2022 |
7.1.0-Beta-1 | 196 | 7/4/2022 |
7.0.5 | 92 | 6/3/2024 |
7.0.4 | 151 | 11/12/2023 |
7.0.3 | 1,511 | 3/21/2022 |
7.0.2 | 555 | 2/8/2022 |
7.0.1 | 437 | 10/29/2021 |
7.0.0 | 457 | 6/2/2021 |
6.0.13 | 161 | 4/4/2024 |
6.0.12 | 13,533 | 11/10/2023 |
6.0.11 | 721 | 1/12/2023 |
6.0.10 | 752 | 4/29/2022 |
6.0.9 | 631 | 2/2/2022 |
6.0.8 | 498 | 10/28/2021 |
6.0.7 | 50,335 | 8/27/2021 |
6.0.6 | 500 | 5/24/2021 |
6.0.5 | 718 | 3/9/2021 |
6.0.4 | 12,366 | 12/22/2020 |
6.0.3 | 595 | 9/29/2020 |
6.0.0 | 1,250 | 1/28/2020 |
5.1.0-Beta-1 | 1,310 | 1/30/2015 |
5.0.24 | 491 | 4/27/2021 |
5.0.23 | 472 | 2/4/2021 |
5.0.22 | 641 | 11/18/2020 |
5.0.21 | 591 | 11/6/2020 |
5.0.20 | 760 | 12/25/2019 |
5.0.19 | 18,149 | 5/30/2019 |
5.0.19-Beta-2 | 734 | 4/16/2019 |
5.0.19-Beta-1 | 619 | 12/29/2018 |
5.0.18 | 3,798 | 9/28/2018 |
5.0.18-Beta-3 | 793 | 7/2/2018 |
5.0.18-Beta-2 | 842 | 6/6/2018 |
5.0.18-Beta-1 | 801 | 4/24/2018 |
5.0.17 | 1,486 | 2/27/2018 |
5.0.17-Beta-3 | 908 | 2/12/2018 |
5.0.17-Beta-2 | 880 | 1/12/2018 |
5.0.17-Beta-1 | 973 | 12/28/2017 |
5.0.16 | 1,166 | 12/1/2017 |
5.0.16-Beta-1 | 826 | 9/27/2017 |
5.0.15 | 1,201 | 8/1/2017 |
5.0.14 | 1,158 | 6/19/2017 |
5.0.13 | 1,301 | 3/22/2017 |
5.0.12 | 1,150 | 2/14/2017 |
5.0.11 | 1,073 | 1/25/2017 |
5.0.11-RC2 | 834 | 12/16/2016 |
5.0.11-RC | 1,158 | 9/20/2016 |
5.0.10 | 1,095 | 8/5/2016 |
5.0.10-RC | 829 | 6/30/2016 |
5.0.9 | 1,394 | 3/3/2016 |
5.0.8 | 1,230 | 2/15/2016 |
5.0.7 | 1,235 | 1/27/2016 |
5.0.7-RC2 | 839 | 12/8/2015 |
5.0.7-RC | 895 | 9/10/2015 |
5.0.6 | 1,257 | 7/3/2015 |
5.0.5 | 1,430 | 4/23/2015 |
5.0.4 | 1,251 | 3/19/2015 |
5.0.4-RC | 1,191 | 2/25/2015 |
5.0.3 | 1,901 | 10/31/2014 |
5.0.2 | 1,254 | 9/11/2014 |
5.0.0 | 1,263 | 8/15/2014 |
5.0.0-RC2 | 936 | 8/1/2014 |
5.0.0-RC | 950 | 7/21/2014 |
5.0.0-Beta-3 | 935 | 5/28/2014 |
5.0.0-Beta-2 | 1,010 | 2/28/2014 |
5.0.0-Beta-1 | 991 | 11/14/2013 |
4.6.9 | 1,208 | 7/3/2015 |
4.6.8 | 1,207 | 8/1/2014 |
4.6.7 | 1,278 | 6/23/2014 |
4.6.6 | 1,415 | 4/9/2014 |
4.6.5 | 1,285 | 1/7/2014 |
4.6.4 | 2,867 | 9/30/2013 |
4.6.3 | 2,080 | 2/4/2013 |
4.6.2 | 1,689 | 11/28/2012 |
4.6.0 | 1,504 | 10/11/2012 |
4.6.0-RC | 1,094 | 10/4/2012 |
4.5.8 | 1,223 | 9/30/2013 |
4.5.7 | 1,356 | 2/4/2013 |
4.5.6 | 1,474 | 11/28/2012 |
4.5.5 | 1,442 | 10/11/2012 |
4.5.5-RC | 1,133 | 10/4/2012 |
4.5.3 | 1,423 | 8/6/2012 |
4.5.2 | 1,496 | 5/10/2012 |
4.5.0 | 1,603 | 3/13/2012 |