Shaolinq.SqlServer 1.9.4

Shaolinq ORM and Linq provider for SQL Server

Shaolinq is a thoughtfully designed ORM and Linq provider for .NET
   
Use this package to add Shaolinq and out-of-the-box MySql support.
   
Designed to perform super fast and be easy to use, Shaolinq's features also include:
   
- First class schema-first ORM with WYSIWYG data access and minipulation.
- First class LINQ support (not the basic kind you see in most other OSS projects).
- Single trip updating of objects.
- Support for Sqlite, MySql, Postgres and SQL Server.
- Automatic database creation and schema migration.
- Delete LINQ extension for batch server side deletes.
- Full support for server side date functions (Date.DayOfWeek etc).
- Easily extensible with a simple interface for adding support for other ADO.NET compatible databases.
- Open Source!

Install-Package Shaolinq.SqlServer -Version 1.9.4
dotnet add package Shaolinq.SqlServer --version 1.9.4
<PackageReference Include="Shaolinq.SqlServer" Version="1.9.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.SqlServer --version 1.9.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

# 1.9.4
- Fixed bug where comparing a nullable enum property to nullable enum variable can throw an exception if the variable is null.
# 1.9.3
- Added IDataAccessObjectAdvanced.DeflatedPredicate property.
# 1.9.2
- Added DataAccessModel.GetReference{T}(id)  where T : DataAccessObject method.
# 1.9.1
- Allow querying new objects while committing by disabling transaction-context object cache (DataAccessObjectDataContext).
This can occur if there are any computed properties that need to perform additional queries (including implicit N+1 queries from dereferencing child properties) in order to generate the property value.
# 1.9.0
- Fixed potential query caching problems when using queries that include predicated deflated references.

Version History

Version Downloads Last updated
1.9.4 211 11/9/2018
1.9.3.1445-fix-null-enum-bug 93 11/9/2018
1.9.3 100 11/9/2018
1.9.1.1438-feature-allow-re... 112 10/23/2018
1.9.1 133 10/23/2018
1.9.0.1437-feature-model-ge... 105 10/21/2018
1.9.0.1435-fix-query-cachin... 115 10/18/2018
1.9.0 137 10/18/2018
1.8.15 129 10/17/2018
1.8.14.1433-fix-nested-quer... 97 10/17/2018
1.8.14 116 10/16/2018
1.8.13.1429-fix-fix-nested-... 113 10/15/2018
1.8.13 121 10/15/2018
1.8.12 158 10/2/2018
1.8.11.1420-feature-allow-i... 103 10/2/2018
1.8.11.1419-feature-allow-i... 114 10/1/2018
1.8.11.1418-feature-allow-i... 142 10/1/2018
1.8.11 141 9/25/2018
1.8.10.1416-fix-distinct-co... 121 9/25/2018
1.8.10 176 8/16/2018
1.8.9 136 8/16/2018
1.8.8.1409-feature-sqlserve... 137 8/13/2018
1.8.8 144 8/10/2018
1.8.7.1404-fix-sql-index-an... 121 8/10/2018
1.8.7 154 8/10/2018
1.8.6 138 8/8/2018
1.8.4.1394-feature-exclude-... 136 8/7/2018
1.8.4 149 8/7/2018
1.8.3.1391-feature-unique-i... 139 8/7/2018
1.8.3 158 8/6/2018
1.8.2.1387-fix-support-over... 144 8/6/2018
1.8.2 146 8/2/2018
1.8.1.1384-fix-computed-mem... 133 8/1/2018
1.8.1.1383-fix-computed-mem... 129 8/1/2018
1.8.1 181 7/29/2018
1.8.0 144 7/28/2018
1.7.2 150 7/23/2018
1.7.1 144 7/22/2018
1.7.0.1340-feature-support-... 159 7/22/2018
1.7.0.1338-feature-support-... 139 7/22/2018
1.7.0 144 7/22/2018
1.6.0.1329-feature-naming-t... 135 7/21/2018
1.5.0.1304 138 7/20/2018
1.5.0.1303-feature-class-le... 136 7/20/2018
1.5.0.1300 193 6/4/2018
1.5.0.1296-fix-datacontext-... 287 5/6/2018
1.5.0.1295 223 4/26/2018
1.5.0.1294 191 4/26/2018
1.5.0.1285 225 2/6/2018
1.5.0.1285-asynchooks-test 200 2/6/2018
1.5.0.1280-asynchooks-test 201 2/5/2018
1.3.1.1240 229 1/23/2018
1.3.1.1208 203 1/17/2018
1.3.1.1207 226 1/8/2018
1.3.1.1206 205 1/8/2018
1.3.1.1204 191 1/3/2018
1.3.1.1198 226 12/21/2017
1.3.1.1195 206 12/1/2017
1.3.1.1194 178 12/1/2017
1.3.1.1193 179 12/1/2017
1.3.1.1171 244 10/17/2017
1.3.1.1163 275 7/5/2017
1.3.1.1160 229 6/21/2017
1.3.1.1159 214 6/21/2017
1.3.1.1155 209 6/20/2017
1.3.1.1153 241 6/19/2017
1.3.1.1151 228 6/16/2017
1.3.1.1148 242 6/15/2017
1.3.0.1144 220 6/12/2017
1.3.0.1141 257 6/9/2017
1.3.0.1137 243 5/12/2017
1.3.0.1135 237 5/11/2017
1.3.0.1134 243 5/11/2017
1.3.0.1131 265 5/6/2017
1.3.0.1130 251 5/6/2017
1.3.0.1129 220 5/5/2017
1.3.0.1128 231 5/5/2017
1.2.0.1118 230 5/4/2017
1.2.0.1116 245 5/4/2017
1.2.0.1114 234 5/4/2017
1.2.0.1112 220 5/4/2017
1.2.0.1111 247 5/3/2017
1.2.0.1107 222 5/2/2017
1.2.0.1104 230 4/29/2017
1.2.0.1103 234 4/28/2017
1.2.0.1101 219 4/28/2017
1.2.0.1095 229 4/27/2017
1.2.0.1092 222 4/18/2017
1.2.0.1088 234 4/17/2017
1.2.0.1087 254 4/17/2017
1.2.0.1086 223 4/17/2017
1.2.0.1085 223 4/17/2017
1.2.0.1084 223 4/17/2017
1.2.0.1072-rc1 238 4/14/2017
1.2.0.1071-rc1 196 4/14/2017
1.2.0.1064-rc1 205 4/1/2017
1.2.0.1061-rc1 201 3/31/2017
1.2.0.1059-rc1 210 3/29/2017
1.2.0.1057-rc1 212 3/28/2017
1.2.0.1055-rc1 198 3/28/2017
1.1.1.1044 257 3/24/2017
1.1.1.1040 237 3/19/2017
1.1.1.1004 231 3/10/2017
1.1.1.1002 228 3/9/2017
1.1.1.1000 315 2/1/2017
1.1.1.998 265 1/31/2017
1.1.1.996 322 12/15/2016
1.1.1.991 275 11/28/2016
1.1.1.989 307 9/22/2016
1.1.1.987 257 9/22/2016
1.1.1.986 241 9/22/2016
1.1.1.985 265 9/22/2016
1.1.1.982 268 8/24/2016
1.1.1.980 280 8/24/2016
1.1.1.979 282 8/22/2016
1.1.0.975 251 8/22/2016
1.1.0.973 264 8/22/2016
1.1.0.972 252 8/22/2016
1.1.0.971 257 8/18/2016
1.1.0.970 259 8/16/2016
1.1.0.967 270 8/15/2016
1.1.0.966 278 8/15/2016
1.1.0.964 253 8/11/2016
1.1.0.963 299 8/9/2016
1.1.0.961 275 8/9/2016
1.1.0.960 275 8/9/2016
1.1.0.959 263 8/8/2016
1.1.0.957 274 8/7/2016
1.1.0.956 255 8/7/2016
1.1.0.947-rc 252 8/6/2016
1.1.0.946-rc 238 8/5/2016
1.1.0.945 257 8/5/2016
1.1.0.942 304 7/27/2016
1.1.0.941 297 7/27/2016
1.1.0.939 287 7/27/2016
1.1.0.938 301 7/27/2016
1.1.0.936 305 7/26/2016
1.1.0.935 287 7/26/2016
1.1.0.932 292 7/25/2016
1.1.0.930 276 7/23/2016
1.1.0.929 293 7/23/2016
1.1.0.928 288 7/22/2016
1.1.0.927 310 7/22/2016
1.1.0.924 348 7/22/2016
1.1.0.923 276 7/21/2016
1.1.0.918 250 7/20/2016
1.1.0.915 247 7/20/2016
1.1.0.912 277 7/20/2016
1.1.0.910 261 7/20/2016
1.1.0.904 273 7/19/2016
1.1.0.903 252 7/18/2016
1.1.0.902 249 7/18/2016
1.1.0.901 280 7/18/2016
1.1.0.887 283 7/16/2016
1.1.0.886 289 7/16/2016
1.1.0.883 402 7/14/2016
1.1.0.879 430 7/13/2016
1.1.0.877 402 7/12/2016
1.1.0.864 268 7/9/2016
1.1.0.863 272 7/9/2016
1.1.0.859 279 7/8/2016
1.1.0.858 254 7/8/2016
1.1.0.857 273 7/6/2016
1.1.0.856 258 6/29/2016
1.1.0.855 247 6/28/2016
1.1.0.854 269 6/25/2016
1.0.1.851-rc 236 6/17/2016
1.0.1.849-rc 223 6/17/2016
1.0.1.842-rc 262 6/9/2016
1.0.1.841-rc 252 6/9/2016
1.0.1.839-rc 254 6/9/2016
1.0.1.837-rc 325 5/31/2016
1.0.1.835-rc 260 5/26/2016
1.0.1.834-rc 255 5/24/2016
1.0.1.833-rc 268 5/20/2016
1.0.1.832-rc 252 5/20/2016
1.0.1.828-rc 252 5/9/2016
1.0.1.827-rc 253 5/7/2016
1.0.1.826-rc 271 5/2/2016
1.0.1.824-rc 281 5/1/2016
1.0.1.823-rc 258 4/21/2016
1.0.1.822-rc 231 4/20/2016
1.0.1.821-rc 259 4/11/2016
1.0.1.819-rc 299 4/11/2016
1.0.1.818-rc 242 4/8/2016
1.0.1.817-rc 246 4/7/2016
1.0.1.813-rc 247 4/7/2016
1.0.1.812-rc 292 3/30/2016
1.0.1.811-rc 253 3/30/2016
1.0.1.810-rc 240 3/30/2016
1.0.1.808-rc 241 3/30/2016
1.0.1.807-rc 266 3/29/2016
1.0.1.806-rc 249 3/29/2016
1.0.1.805-rc 243 3/29/2016
1.0.1.796-rc 246 3/27/2016
1.0.1.793-rc 275 3/27/2016
1.0.1.788-rc 257 3/26/2016
1.0.1.785-rc 273 3/26/2016
1.0.1.778-rc 264 3/22/2016
1.0.1.777-rc 271 3/22/2016
1.0.1.776-rc 238 3/18/2016
1.0.1.775-rc 259 3/18/2016
1.0.1.774-rc 255 3/16/2016
1.0.1.773-rc 250 3/16/2016
1.0.1.771-rc 240 3/15/2016
1.0.1.769-rc 246 3/15/2016
1.0.1.765-rc 228 3/15/2016
1.0.1.764-rc 246 3/15/2016
1.0.1.759-rc 284 3/14/2016
1.0.1.758-rc 234 3/14/2016
1.0.1.757-rc 235 3/14/2016
1.0.1.752-rc 264 3/13/2016
1.0.1.748-rc 275 3/13/2016
1.0.1.747-rc 276 3/13/2016
1.0.1.746-rc 278 3/13/2016
1.0.1.743-rc 244 3/9/2016
1.0.1.742-rc 244 3/8/2016
1.0.1.741-rc 236 3/8/2016
1.0.1.740-rc 260 3/7/2016
1.0.1.736-rc 237 3/7/2016
1.0.1.735-rc 268 3/7/2016
1.0.1.729-rc 240 3/6/2016
1.0.1.728-rc 244 3/6/2016
1.0.1.726-rc 247 3/6/2016
1.0.1.724-rc 290 3/4/2016
1.0.1.723-rc 268 3/3/2016
1.0.1.722-rc 242 3/3/2016
1.0.1.721-rc 261 3/3/2016
1.0.1.719-rc 249 3/2/2016
1.0.1.717-rc 270 3/1/2016
1.0.1.716-rc 293 2/28/2016
1.0.1.711-rc 309 2/28/2016
1.0.1.709-rc 313 2/27/2016
1.0.1.708-rc 306 2/27/2016
1.0.1.707-rc 312 2/27/2016
1.0.1.706-rc 304 2/26/2016
1.0.1.705-rc 335 2/26/2016
1.0.1.701-rc 274 2/25/2016
1.0.1.699-rc 258 2/23/2016
1.0.1.696-rc 282 2/21/2016
1.0.1.693-rc 242 2/20/2016
1.0.1.691-rc 265 2/19/2016
1.0.1.689-rc 238 2/19/2016
1.0.1.684-rc 240 2/18/2016
1.0.1.683-rc 235 2/18/2016
1.0.1.676-rc 238 2/17/2016
1.0.1.673-rc 256 2/17/2016
1.0.1.670-rc 243 2/17/2016
1.0.1.665-rc 270 2/15/2016
1.0.1.663-rc 263 2/14/2016
1.0.1.659-rc 230 2/14/2016
1.0.1.657-rc 232 2/14/2016
1.0.1.654-rc 312 2/14/2016
1.0.1.648-rc 303 2/13/2016
1.0.1.647-rc 242 2/13/2016
1.0.1.632-rc 244 2/11/2016
1.0.1.631-rc 265 2/11/2016
1.0.1.626-rc 228 2/10/2016
1.0.1.625-rc 244 2/10/2016
1.0.1.609-rc 262 2/4/2016
1.0.1.605-rc 243 2/4/2016
1.0.1.604-rc 248 2/4/2016
1.0.1.600-rc 234 1/28/2016
1.0.1.597-rc 250 1/27/2016
1.0.1.596-rc 317 1/26/2016
1.0.1.595-rc 265 1/22/2016
1.0.1.593-rc 246 1/22/2016
1.0.1.590-rc 259 1/21/2016
1.0.1.588-rc 290 1/20/2016
1.0.1.583-rc 246 1/20/2016
1.0.1.582-rc 270 1/20/2016
1.0.1.574-rc 268 1/19/2016
1.0.1.571-rc 250 1/19/2016
1.0.1.570-rc 272 1/18/2016
1.0.1.569-rc 238 1/17/2016
1.0.1.568-rc 254 1/15/2016
1.0.1.565-rc 261 1/8/2016
1.0.1.564-rc 270 1/8/2016
1.0.1.561-rc 273 1/6/2016
1.0.1.557-rc 269 1/3/2016
1.0.1.554-rc 294 12/22/2015
1.0.1.553-rc 277 12/22/2015
1.0.1.552-rc 284 12/22/2015
1.0.1.551-rc 245 12/21/2015
1.0.1.550-rc 247 12/20/2015
1.0.1.545-rc 257 12/17/2015
1.0.1.543-rc 238 12/17/2015
1.0.1.542-rc 248 12/16/2015
1.0.1.539-rc 263 12/16/2015
1.0.1.525-rc 282 12/16/2015
1.0.1.521-rc 272 12/15/2015
1.0.1.512-rc 269 12/14/2015
1.0.1.508-rc 244 12/14/2015
1.0.1.505-rc 271 12/14/2015
1.0.0.492-rc 300 12/11/2015
1.0.0.491-rc 313 12/11/2015
1.0.0.488-rc 316 12/11/2015
1.0.0.487-rc 282 12/11/2015
1.0.0.485-rc 243 12/9/2015
1.0.0.481-rc 258 12/8/2015
1.0.0.479-rc 252 12/7/2015
1.0.0.473-rc 253 12/6/2015
1.0.0.472-rc 248 12/3/2015
1.0.0.469-rc 296 12/1/2015
1.0.0.465-rc 262 11/19/2015
1.0.0.464-rc 272 11/16/2015
1.0.0.458-rc 307 11/3/2015
1.0.0.448-rc 265 10/27/2015
1.0.0.447-rc 269 10/27/2015
1.0.0.446-rc 289 10/27/2015
1.0.0.443-rc 246 10/27/2015
1.0.0.441-rc 267 10/26/2015
1.0.0.436-rc 252 10/26/2015
1.0.0.434-rc 278 10/26/2015
1.0.0.433-rc 250 10/26/2015
0.9.1.426 382 10/8/2015
0.9.1.424 300 10/6/2015
0.9.1.418 316 9/29/2015
0.9.1.415 294 9/29/2015
0.9.1.411 306 9/28/2015
0.9.1.408 320 9/3/2015
0.9.1.407 322 8/18/2015
0.9.1.406 323 8/13/2015
0.9.1.405 293 8/13/2015
0.9.1.404 319 8/13/2015
0.9.1.401 423 7/21/2015
0.9.1.395 388 7/5/2015
0.9.1.394 339 7/4/2015
0.9.1.393 311 7/4/2015
0.9.1.390 350 6/13/2015
0.9.1.388 287 6/13/2015
0.9.1.386 295 6/13/2015
0.9.1.385 300 6/12/2015
0.9.1.382 291 6/12/2015
0.9.1.381 277 6/12/2015
0.9.1.380 289 6/12/2015
0.9.1.378 282 6/12/2015
0.9.1.375 337 2/27/2015
0.9.1.373 447 2/25/2015
0.9.1.370 295 2/25/2015
0.9.1.367 370 2/23/2015
0.9.1.365 427 2/21/2015
0.9.1.361 328 2/21/2015
0.9.1.358 385 2/16/2015
0.9.1.357 305 2/11/2015
0.9.0.355 291 2/10/2015
0.9.0.354 310 2/1/2015
0.9.0.353 311 1/30/2015