Shaolinq.Sqlite 1.9.4

Shaolinq ORM and Linq provider for Sqlite

Shaolinq is a thoughtfully designed ORM and Linq provider for .NET
   
Use this package to add Shaolinq and out-of-the-box Sqlite 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 and Postgres.
- 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.Sqlite -Version 1.9.4
dotnet add package Shaolinq.Sqlite --version 1.9.4
<PackageReference Include="Shaolinq.Sqlite" Version="1.9.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.Sqlite --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 225 11/9/2018
1.9.3.1445-fix-null-enum-bug 92 11/9/2018
1.9.3 104 11/9/2018
1.9.1.1438-feature-allow-re... 121 10/23/2018
1.9.1 153 10/23/2018
1.9.0.1437-feature-model-ge... 111 10/21/2018
1.9.0.1435-fix-query-cachin... 110 10/18/2018
1.9.0 140 10/18/2018
1.8.15 129 10/17/2018
1.8.14.1433-fix-nested-quer... 99 10/17/2018
1.8.14 119 10/16/2018
1.8.13.1429-fix-fix-nested-... 111 10/15/2018
1.8.13 127 10/15/2018
1.8.12 168 10/2/2018
1.8.11.1420-feature-allow-i... 124 10/2/2018
1.8.11.1419-feature-allow-i... 132 10/1/2018
1.8.11.1418-feature-allow-i... 112 10/1/2018
1.8.11 170 9/25/2018
1.8.10.1416-fix-distinct-co... 110 9/25/2018
1.8.10 195 8/16/2018
1.8.9 140 8/16/2018
1.8.8.1409-feature-sqlserve... 137 8/13/2018
1.8.8 151 8/10/2018
1.8.7.1404-fix-sql-index-an... 125 8/10/2018
1.8.7 168 8/10/2018
1.8.6 144 8/8/2018
1.8.4.1394-feature-exclude-... 143 8/7/2018
1.8.4 153 8/7/2018
1.8.3.1391-feature-unique-i... 135 8/7/2018
1.8.3 159 8/6/2018
1.8.2.1387-fix-support-over... 146 8/6/2018
1.8.2 156 8/2/2018
1.8.1.1384-fix-computed-mem... 143 8/1/2018
1.8.1.1383-fix-computed-mem... 134 8/1/2018
1.8.1 162 7/29/2018
1.8.0 145 7/28/2018
1.7.2 148 7/23/2018
1.7.1 144 7/22/2018
1.7.0.1340-feature-support-... 139 7/22/2018
1.7.0.1338-feature-support-... 144 7/22/2018
1.7.0 148 7/22/2018
1.6.0.1329-feature-naming-t... 143 7/21/2018
1.5.0.1304 149 7/20/2018
1.5.0.1303-feature-class-le... 137 7/20/2018
1.5.0.1300 221 6/4/2018
1.5.0.1296-fix-datacontext-... 298 5/6/2018
1.5.0.1295 235 4/26/2018
1.5.0.1294 173 4/26/2018
1.5.0.1285 291 2/6/2018
1.5.0.1285-asynchooks-test 196 2/6/2018
1.5.0.1280-asynchooks-test 209 2/5/2018
1.3.1.1240 304 1/23/2018
1.3.1.1208 218 1/17/2018
1.3.1.1207 226 1/8/2018
1.3.1.1206 220 1/8/2018
1.3.1.1204 229 1/3/2018
1.3.1.1198 243 12/21/2017
1.3.1.1195 212 12/1/2017
1.3.1.1194 185 12/1/2017
1.3.1.1193 185 12/1/2017
1.3.1.1171 235 10/17/2017
1.3.1.1163 317 7/5/2017
1.3.1.1160 249 6/21/2017
1.3.1.1159 221 6/21/2017
1.3.1.1155 257 6/20/2017
1.3.1.1153 228 6/19/2017
1.3.1.1151 236 6/16/2017
1.3.1.1148 229 6/15/2017
1.3.0.1144 235 6/12/2017
1.3.0.1141 244 6/9/2017
1.3.0.1137 261 5/12/2017
1.3.0.1135 231 5/11/2017
1.3.0.1134 223 5/11/2017
1.3.0.1131 242 5/6/2017
1.3.0.1130 219 5/6/2017
1.3.0.1129 225 5/5/2017
1.3.0.1128 231 5/5/2017
1.2.0.1118 228 5/4/2017
1.2.0.1116 226 5/4/2017
1.2.0.1114 236 5/4/2017
1.2.0.1112 221 5/4/2017
1.2.0.1111 226 5/3/2017
1.2.0.1107 230 5/2/2017
1.2.0.1104 234 4/29/2017
1.2.0.1103 223 4/28/2017
1.2.0.1101 225 4/28/2017
1.2.0.1095 230 4/27/2017
1.2.0.1092 235 4/18/2017
1.2.0.1088 229 4/17/2017
1.2.0.1087 228 4/17/2017
1.2.0.1086 229 4/17/2017
1.2.0.1085 221 4/17/2017
1.2.0.1084 223 4/17/2017
1.2.0.1072-rc1 212 4/14/2017
1.2.0.1071-rc1 197 4/14/2017
1.2.0.1064-rc1 212 4/1/2017
1.2.0.1061-rc1 207 3/31/2017
1.2.0.1059-rc1 207 3/29/2017
1.2.0.1057-rc1 207 3/28/2017
1.2.0.1055-rc1 203 3/28/2017
1.1.1.1044 262 3/24/2017
1.1.1.1040 247 3/19/2017
1.1.1.1004 247 3/10/2017
1.1.1.1002 250 3/9/2017
1.1.1.1000 321 2/1/2017
1.1.1.998 254 1/31/2017
1.1.1.996 366 12/15/2016
1.1.1.991 307 11/28/2016
1.1.1.989 359 9/22/2016
1.1.1.987 251 9/22/2016
1.1.1.986 249 9/22/2016
1.1.1.985 250 9/22/2016
1.1.1.982 297 8/24/2016
1.1.1.980 271 8/24/2016
1.1.1.979 278 8/22/2016
1.1.0.975 298 8/22/2016
1.1.0.973 248 8/22/2016
1.1.0.972 251 8/22/2016
1.1.0.971 271 8/18/2016
1.1.0.970 275 8/16/2016
1.1.0.967 271 8/15/2016
1.1.0.966 310 8/15/2016
1.1.0.964 269 8/11/2016
1.1.0.963 315 8/9/2016
1.1.0.961 250 8/9/2016
1.1.0.960 284 8/9/2016
1.1.0.959 270 8/8/2016
1.1.0.957 280 8/7/2016
1.1.0.956 258 8/7/2016
1.1.0.947-rc 227 8/6/2016
1.1.0.946-rc 240 8/5/2016
1.1.0.945 263 8/5/2016
1.1.0.942 317 7/27/2016
1.1.0.941 294 7/27/2016
1.1.0.939 303 7/27/2016
1.1.0.938 304 7/27/2016
1.1.0.936 291 7/26/2016
1.1.0.935 284 7/26/2016
1.1.0.932 301 7/25/2016
1.1.0.930 290 7/23/2016
1.1.0.929 311 7/23/2016
1.1.0.928 289 7/22/2016
1.1.0.927 300 7/22/2016
1.1.0.924 342 7/22/2016
1.1.0.923 297 7/21/2016
1.1.0.918 266 7/20/2016
1.1.0.915 253 7/20/2016
1.1.0.912 273 7/20/2016
1.1.0.910 252 7/20/2016
1.1.0.904 292 7/19/2016
1.1.0.903 251 7/18/2016
1.1.0.902 251 7/18/2016
1.1.0.901 270 7/18/2016
1.1.0.887 324 7/16/2016
1.1.0.886 264 7/16/2016
1.1.0.883 443 7/14/2016
1.1.0.879 434 7/13/2016
1.1.0.877 414 7/12/2016
1.1.0.864 279 7/9/2016
1.1.0.863 298 7/9/2016
1.1.0.859 284 7/8/2016
1.1.0.858 278 7/8/2016
1.1.0.857 303 7/6/2016
1.1.0.856 285 6/29/2016
1.1.0.855 277 6/28/2016
1.1.0.854 254 6/25/2016
1.0.1.851-rc 241 6/17/2016
1.0.1.849-rc 233 6/17/2016
1.0.1.842-rc 281 6/9/2016
1.0.1.841-rc 252 6/9/2016
1.0.1.839-rc 260 6/9/2016
1.0.1.837-rc 335 5/31/2016
1.0.1.835-rc 254 5/26/2016
1.0.1.834-rc 272 5/24/2016
1.0.1.833-rc 266 5/20/2016
1.0.1.832-rc 253 5/20/2016
1.0.1.828-rc 275 5/9/2016
1.0.1.827-rc 236 5/7/2016
1.0.1.826-rc 272 5/2/2016
1.0.1.824-rc 270 5/1/2016
1.0.1.823-rc 269 4/21/2016
1.0.1.822-rc 243 4/20/2016
1.0.1.821-rc 268 4/11/2016
1.0.1.819-rc 313 4/11/2016
1.0.1.818-rc 244 4/8/2016
1.0.1.817-rc 264 4/7/2016
1.0.1.813-rc 251 4/7/2016
1.0.1.812-rc 503 3/30/2016
1.0.1.811-rc 275 3/30/2016
1.0.1.810-rc 243 3/30/2016
1.0.1.808-rc 244 3/30/2016
1.0.1.807-rc 284 3/29/2016
1.0.1.806-rc 278 3/29/2016
1.0.1.805-rc 259 3/29/2016
1.0.1.796-rc 263 3/27/2016
1.0.1.793-rc 248 3/27/2016
1.0.1.788-rc 249 3/26/2016
1.0.1.785-rc 288 3/26/2016
1.0.1.778-rc 294 3/22/2016
1.0.1.777-rc 237 3/22/2016
1.0.1.776-rc 233 3/18/2016
1.0.1.775-rc 269 3/18/2016
1.0.1.774-rc 260 3/16/2016
1.0.1.773-rc 275 3/16/2016
1.0.1.771-rc 243 3/15/2016
1.0.1.769-rc 243 3/15/2016
1.0.1.765-rc 278 3/15/2016
1.0.1.764-rc 276 3/15/2016
1.0.1.759-rc 292 3/14/2016
1.0.1.758-rc 240 3/14/2016
1.0.1.757-rc 229 3/14/2016
1.0.1.752-rc 243 3/13/2016
1.0.1.748-rc 253 3/13/2016
1.0.1.747-rc 248 3/13/2016
1.0.1.746-rc 259 3/13/2016
1.0.1.743-rc 226 3/9/2016
1.0.1.742-rc 237 3/8/2016
1.0.1.741-rc 285 3/8/2016
1.0.1.740-rc 275 3/7/2016
1.0.1.736-rc 264 3/7/2016
1.0.1.735-rc 282 3/7/2016
1.0.1.729-rc 261 3/6/2016
1.0.1.728-rc 274 3/6/2016
1.0.1.726-rc 257 3/6/2016
1.0.1.724-rc 283 3/4/2016
1.0.1.723-rc 245 3/3/2016
1.0.1.722-rc 283 3/3/2016
1.0.1.721-rc 273 3/3/2016
1.0.1.719-rc 238 3/2/2016
1.0.1.717-rc 253 3/1/2016
1.0.1.716-rc 309 2/28/2016
1.0.1.711-rc 297 2/28/2016
1.0.1.709-rc 285 2/27/2016
1.0.1.708-rc 278 2/27/2016
1.0.1.707-rc 321 2/27/2016
1.0.1.706-rc 281 2/26/2016
1.0.1.705-rc 309 2/26/2016
1.0.1.701-rc 261 2/25/2016
1.0.1.699-rc 239 2/23/2016
1.0.1.696-rc 311 2/21/2016
1.0.1.693-rc 279 2/20/2016
1.0.1.691-rc 236 2/19/2016
1.0.1.689-rc 248 2/19/2016
1.0.1.684-rc 264 2/18/2016
1.0.1.683-rc 242 2/18/2016
1.0.1.676-rc 242 2/17/2016
1.0.1.673-rc 247 2/17/2016
1.0.1.670-rc 246 2/17/2016
1.0.1.665-rc 270 2/15/2016
1.0.1.663-rc 275 2/14/2016
1.0.1.659-rc 278 2/14/2016
1.0.1.657-rc 277 2/14/2016
1.0.1.654-rc 290 2/14/2016
1.0.1.648-rc 280 2/13/2016
1.0.1.647-rc 284 2/13/2016
1.0.1.632-rc 247 2/11/2016
1.0.1.631-rc 248 2/11/2016
1.0.1.626-rc 241 2/10/2016
1.0.1.625-rc 241 2/10/2016
1.0.1.609-rc 258 2/4/2016
1.0.1.605-rc 262 2/4/2016
1.0.1.604-rc 296 2/4/2016
1.0.1.600-rc 252 1/28/2016
1.0.1.597-rc 242 1/27/2016
1.0.1.596-rc 365 1/26/2016
1.0.1.595-rc 255 1/22/2016
1.0.1.593-rc 279 1/22/2016
1.0.1.590-rc 254 1/21/2016
1.0.1.588-rc 307 1/20/2016
1.0.1.583-rc 263 1/20/2016
1.0.1.582-rc 262 1/20/2016
1.0.1.574-rc 258 1/19/2016
1.0.1.571-rc 237 1/19/2016
1.0.1.570-rc 257 1/18/2016
1.0.1.569-rc 241 1/17/2016
1.0.1.568-rc 309 1/15/2016
1.0.1.565-rc 279 1/8/2016
1.0.1.564-rc 247 1/8/2016
1.0.1.561-rc 245 1/6/2016
1.0.1.557-rc 252 1/3/2016
1.0.1.554-rc 300 12/22/2015
1.0.1.553-rc 292 12/22/2015
1.0.1.552-rc 300 12/22/2015
1.0.1.551-rc 252 12/21/2015
1.0.1.550-rc 246 12/20/2015
1.0.1.545-rc 248 12/17/2015
1.0.1.543-rc 247 12/17/2015
1.0.1.542-rc 287 12/16/2015
1.0.1.539-rc 254 12/16/2015
1.0.1.525-rc 263 12/16/2015
1.0.1.521-rc 262 12/15/2015
1.0.1.512-rc 251 12/14/2015
1.0.1.508-rc 248 12/14/2015
1.0.1.505-rc 256 12/14/2015
1.0.0.492-rc 294 12/11/2015
1.0.0.491-rc 321 12/11/2015
1.0.0.488-rc 293 12/11/2015
1.0.0.487-rc 288 12/11/2015
1.0.0.485-rc 266 12/9/2015
1.0.0.481-rc 265 12/8/2015
1.0.0.479-rc 258 12/7/2015
1.0.0.473-rc 245 12/6/2015
1.0.0.472-rc 255 12/3/2015
1.0.0.469-rc 289 12/1/2015
1.0.0.465-rc 259 11/19/2015
1.0.0.464-rc 277 11/16/2015
1.0.0.458-rc 264 11/3/2015
1.0.0.448-rc 265 10/27/2015
1.0.0.447-rc 257 10/27/2015
1.0.0.446-rc 271 10/27/2015
1.0.0.443-rc 266 10/27/2015
1.0.0.441-rc 282 10/26/2015
1.0.0.436-rc 270 10/26/2015
1.0.0.434-rc 270 10/26/2015
1.0.0.433-rc 268 10/26/2015
0.9.1.426 520 10/8/2015
0.9.1.424 300 10/6/2015
0.9.1.418 330 9/29/2015
0.9.1.415 278 9/29/2015
0.9.1.411 325 9/28/2015
0.9.1.408 345 9/3/2015
0.9.1.407 327 8/18/2015
0.9.1.406 308 8/13/2015
0.9.1.405 276 8/13/2015
0.9.1.404 277 8/13/2015
0.9.1.401 408 7/21/2015
0.9.1.395 348 7/5/2015
0.9.1.394 284 7/4/2015
0.9.1.393 295 7/4/2015
0.9.1.390 326 6/13/2015
0.9.1.388 287 6/13/2015
0.9.1.386 293 6/13/2015
0.9.1.385 295 6/12/2015
0.9.1.382 290 6/12/2015
0.9.1.381 304 6/12/2015
0.9.1.380 289 6/12/2015
0.9.1.378 287 6/12/2015
0.9.1.375 442 2/27/2015
0.9.1.373 368 2/25/2015
0.9.1.370 296 2/25/2015
0.9.1.367 404 2/23/2015
0.9.1.365 359 2/21/2015
0.9.1.361 292 2/21/2015
0.9.1.358 370 2/16/2015
0.9.1.357 363 2/11/2015
0.9.0.355 325 2/10/2015
0.9.0.354 307 2/1/2015
0.9.0.353 348 1/30/2015
0.9.0.350 344 1/29/2015
0.9.0.338 331 1/12/2015
0.9.0.328 315 11/25/2014
0.9.0.326 335 11/24/2014
0.9.0.325 311 11/24/2014
0.9.0.323 382 11/23/2014
0.9.0.313 377 11/22/2014
0.9.0.299 463 11/12/2014
0.9.0.295 628 11/12/2014
0.9.0.290 455 11/11/2014
0.9.0.279 656 11/9/2014
0.9.0.269 549 11/6/2014
0.9.0.268 847 11/4/2014
0.9.0.266 1,091 11/3/2014
0.9.0.265 610 11/3/2014
0.9.0.263 848 11/3/2014
0.9.0.262 594 11/3/2014
0.9.0.249 317 10/27/2014
0.9.0.236 314 10/25/2014
0.9.0.234 316 10/24/2014
0.9.0.233 328 10/21/2014
0.9.0.227 305 10/21/2014
0.9.0.226 325 10/21/2014
0.9.0.225 323 10/21/2014
0.9.0.222 343 10/19/2014
0.9.0.221 320 10/19/2014
0.9.0.204 321 10/17/2014
0.9.0.200 337 10/15/2014
0.9.0.199 361 10/15/2014
0.9.0.193 333 10/14/2014
0.9.0.189 317 10/14/2014
0.9.0.184-test 285 10/14/2014
0.9.0.183-test 321 10/13/2014
0.9.0.179 323 10/13/2014
0.9.0.174 334 10/13/2014
0.6.0.173 374 10/13/2014
0.6.0.165 359 10/3/2014
0.6.0.160 393 9/18/2014
0.6.0.157 377 9/18/2014
0.6.0.155 333 9/18/2014
0.6.0.151 309 9/17/2014
0.6.0.147 325 9/16/2014
0.6.0.143 337 9/12/2014
0.6.0.141 375 9/10/2014
0.6.0.139 345 9/3/2014
0.6.0.135 413 8/21/2014
0.6.0.134 380 8/8/2014
0.6.0.130 336 8/4/2014
0.6.0.127 353 7/1/2014
0.6.0.101 361 1/21/2014
0.6.0.97 349 1/16/2014
0.5.0.51 338 1/5/2014
0.5.0.36 330 12/9/2013
0.5.0.35 321 12/8/2013
0.5.0.29 350 12/1/2013
0.5.0.28 340 12/1/2013