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.
Install-Package Symbiotic_Core_x64 -Version 1.0.2
dotnet add package Symbiotic_Core_x64 --version 1.0.2
<PackageReference Include="Symbiotic_Core_x64" Version="1.0.2" />
paket add Symbiotic_Core_x64 --version 1.0.2
#r "nuget: Symbiotic_Core_x64, 1.0.2"
// Install Symbiotic_Core_x64 as a Cake Addin #addin nuget:?package=Symbiotic_Core_x64&version=1.0.2 // Install Symbiotic_Core_x64 as a Cake Tool #tool nuget:?package=Symbiotic_Core_x64&version=1.0.2
' **** Copyright © 2011-2016 Frozen Elephant Inc. ****
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.
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.
Performance: Modified readers to use CommandBehavior.SequentialAccess (not in core version)
Performance: Performance tracking, reviewing default settings.
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.
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.
Working on replacing the Microsoft Encryption code, using PCLCrypto.
Encryption is working.
Need a replacement for Microsoft configuration.
Redesigned encryption implementation.
Now calls the IDatabaseTypesFactory methods to create a IPasswordHasher or IFieldEncrypter.
Have concrete implementation using PLCrypto lib.
Improved error thrown when parameters data values are invalid. Notifies of the parameter name and value.
More error feedback improvements for paramters. Now throws DatabaseParameterException.
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.
Working on Deprecation feature design.
Working on Deprecation feature design.
The deprecation features working, just doing some reviews of the code and design.
- Microsoft.VisualBasic (>= 10.0.0)
- System.Collections (>= 4.0.10)
- System.Collections.Concurrent (>= 4.0.10)
- System.Collections.NonGeneric (>= 4.0.0)
- System.Data.Common (>= 4.0.0)
- System.Diagnostics.Debug (>= 4.0.10)
- System.Diagnostics.Tracing (>= 4.0.20)
- System.Linq (>= 4.0.0)
- System.Linq.Expressions (>= 4.0.10)
- System.Reflection (>= 4.0.10)
- System.Reflection.Extensions (>= 4.0.0)
- System.Reflection.TypeExtensions (>= 4.0.0)
- System.Resources.ResourceManager (>= 4.0.0)
- System.Runtime (>= 4.0.20)
- System.Runtime.Extensions (>= 4.0.10)
- System.Threading (>= 4.0.10)
- System.Threading.Tasks (>= 4.0.10)
- System.Threading.Tasks.Parallel (>= 4.0.0)
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.