Symbiotic_Core_x64 1.0.4

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.

The owner has unlisted this package. This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore.
Install-Package Symbiotic_Core_x64 -Version 1.0.4
dotnet add package Symbiotic_Core_x64 --version 1.0.4
<PackageReference Include="Symbiotic_Core_x64" Version="1.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Symbiotic_Core_x64 --version 1.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Symbiotic_Core_x64, 1.0.4"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Symbiotic_Core_x64 as a Cake Addin
#addin nuget:?package=Symbiotic_Core_x64&version=1.0.4

// Install Symbiotic_Core_x64 as a Cake Tool
#tool nuget:?package=Symbiotic_Core_x64&version=1.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

' ****************************************************
' **** Copyright © 2011-2016 Frozen Elephant Inc. ****
' ****************************************************

21-Feb-2016
Made a few changes to the ColumnDefinition object, it need more details to support new relationship types in the "Symbiotic Helper"
These changes will not affect the orm, they are only used for the helper tools and Data Provider libraries.

25-Feb-2016
Added CommandTimeout to ISqlQuery and also provided overloads to pass in a timeout object loads.
The value get transferred to the command object. I have not needed it, but want it available. Defaults to 30.

02-Mar-2016
Performance: Modified readers to use CommandBehavior.SequentialAccess (not in core version)
Performance: Performance tracking, reviewing default settings.

08-Mar-2016:
Added some parallel support functions, pass in a IList(ISQLQuery) and it farms it out.
Parallel seems to work nice, on my i7 I can see all my cores working.

10-Mar-2016
Working on a portable/core version of symbiotic. Forced to remove some features (Encryption,Dynamics) until I can find a way to include them from another library or something.

15-Mar-2016
Working on replacing the Microsoft Encryption code, using PCLCrypto.

17-Mar-2016
Encryption is working.
Need a replacement for Microsoft configuration.

23-Mar-2016:
Redesigned encryption implementation.
Now calls the IDatabaseTypesFactory methods to create a IPasswordHasher or IFieldEncrypter.
Have concrete implementation using PLCrypto lib.

2-Apr-2016:
Improved error thrown when parameters data values are invalid. Notifies of the parameter name and value.

20-Apr-2016:
More error feedback improvements for paramters. Now throws DatabaseParameterException.

27-Apr-2016:
Adding a feature to allow deprecation of database tables and columns.
The ORM will look in the "Deprecation" table for deprecated tables and columns.
If the usage of a deprecated table or column is found, the ORM will log a warning or raise an exception.
This wil allow developers to more easily transition away from deprecated tables and columns.

29-Apr-2016:
Working on Deprecation feature design.

01-May-2016
Working on Deprecation feature design.

15-May-2016
The deprecation features working, just doing some reviews of the code and design.

25-May-2016
Package update
Added Data providers
Added DatabaseTypesFactories

26-May-2016
Did some refactoring. Ensured all ObjectDatabaseMapper creation is done through the database type factory.
Added more c# versions of the DatabaseTypesFactory classes.

14-Jun-2016
added missing Data.DbType.DateTime to DataTypeMap.CreateTypeMappingDictionaryByDbType

29-Aug-2016
Improving the documentation.

30-Aug-2016
Found and fixed a bug in ObjectWriter.InsertUpdate method when called on Guid primary keys.
Fixed a template for Symbiotic Helper template: C# Change Tracking Property
Improved error caught when loading objects, now tries to provide the column and property name to aid the developer, throws a ColumnLoadException.
Added a new InsertUpdate overload that takes an IEnumerable so you can pass in mixed object types. Wraps the update inside a transaction.

6-Sep-2016
Removed non-empty guid or none-zero id exception on insert. There is valid cases when you want to specify the new primary key. May make this optional validation in a later release.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated