Symbiotic_Micro_ORM_Net_Standard_x64 2.0.2

Symbiotic Micro ORM Net Standard x64

Small and simple to use and understand.
Full object hierarchy CRUD support. Saves all object properties and the relationships to related tables. Also supports collection properties.
Allows developers to write sql as needed for reads. The design just maps the results to the objects. Writes are tightly coupled to the database and build on primary key constraints.
No inheritance requirements, uses either interface implementation or attributes.
Allows developers to modify the relation sql to further optimize loading of children.
Database constraints tolerant.
Lazy initialization support, with child sql override.
Change trackng support to history tables.
Supported databases: Sql Server, My Sql, Sqlite, Oracle, PostgreSql.
Built-in Performance tracking, implement IPerformanceTracking to allow performance tracking of all database actions.
Optimistic concurrency support.
No configuration files needed.
Trace output of SQL statements and parameter values.
Password one way hashing support.
Field level encryption with auto decrypt upon load ability.
Processing intercept support, BeforeInsert, BeforeUpdate, BeforeDelete, AfterLoad.
Database deprecation support.
Paralle Load support.
Validation support.

Install-Package Symbiotic_Micro_ORM_Net_Standard_x64 -Version 2.0.2
dotnet add package Symbiotic_Micro_ORM_Net_Standard_x64 --version 2.0.2
paket add Symbiotic_Micro_ORM_Net_Standard_x64 --version 2.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

3-May-2017
Added overloads on ExecuteScalar to add a new paramter of performCommitClose. This allows developers to run queries with-out closing the transactions, and also query under the same transaction scope.

19-May-2017
Working on new Database Action API. This required some refactoring of the intefaces from a subrutine to a function for implementation of IObjectWriter, IObjectHierarchyWriter.

5-June-2017
Added the entity/object name to thrown exceptions of DatabaseColumnNotFoundException and ColumnLoadException.

9-June-2017
Continued work on new Database Action API. Writing unit tests.

14-June-2017
Improved messages when throwing DatabaseParameterException, now includes the parameter type, also added a missing space between the parameter value and sql label info.

26-June-2017
Found overload issue found by a user, and discovered another error message lacking details. I added the type name of the entity involved to the following excetpion: DatabaseTableAttributeNotFoundException.
Added another overload for InsertUpdate which accepts a factory and IEnumerable.

12-Aug-2017
Improved concurrency error messages.
Continued working on new DatabaseAction processing api.

13-Aug-2017
Continued working on new DatabaseAction processing api. Everything seems to be working. Need to build more unit tests.

1-Sep-2017
Added some code to help identify problem columns/properties that violate valid Sql Server date ranges. It now tells you the column/property name when the date range is bad.
Ref: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

12-Sep-2017
Added missing example projects.

Version History

Version Downloads Last updated
2.0.2 (current version) 33 9/12/2017