Symbiotic_x64 3.1.0

There is a newer version of this package available.
See the version list below for details.

dotnet add package Symbiotic_x64 --version 3.1.0

NuGet\Install-Package Symbiotic_x64 -Version 3.1.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Symbiotic_x64" Version="3.1.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add Symbiotic_x64 --version 3.1.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Symbiotic_x64, 3.1.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install Symbiotic_x64 as a Cake Addin
#addin nuget:?package=Symbiotic_x64&version=3.1.0

// Install Symbiotic_x64 as a Cake Tool
#tool nuget:?package=Symbiotic_x64&version=3.1.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

The main goal of this library is the simplify data access for Object Oriented programmers. This library provides a simple way to perform CRUD operations. It is not expected to work for everyone or every application. Currently works with SQL Server, Sqlite, My Sql and Oracle.
I wanted something that would be simple to use, understand, and have very little impact on the code. With this library, you can have basic object CRUD working in less than three lines of code, and should require less than an hour to understand the library usage.

I also wanted something that could easily be integrated into an existing project.

The basic concept is that you add a few attributes to your objects which explains the mapping to a database results column/s. You can also implement IDatabaseDefineSupport to provide the mapping details.

There a two main objects used to work with the database. ObjectLoader and ObjectWriter.

Product	Compatible and additional computed target framework versions.
.NET Framework	net35 is compatible. net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last updated
4.0.3	153	4/9/2014
4.0.2	47	3/20/2014
4.0.1	47	2/21/2014
3.1.0.3	43	6/3/2013
3.1.0.2	42	3/6/2013
3.1.0.1	42	2/9/2013
3.1.0	49	2/1/2013
3.0.0.2	43	12/20/2012
3.0.0.1	44	12/19/2012
3.0.0	47	12/19/2012
2.6.4	46	11/9/2012
2.6.3	46	11/2/2012
2.6.2	52	10/30/2012
2.6.1	48	10/25/2012

20-21 Dec-2012
Added ExecuteNonQuery, and ExecuteScalar support.
Started wWorking on Optimistic Concurrency.

29-Dec-2012
Still working on Optimistic Concurrency support.

Refactoring Sql Builders to create parameterized versions, and changed the ObjectWriter to use parameters.
Moving to parameters is safer and may also make the ISqlBuilder interface cleaner.
Parameterized sql is typically cached by the database.

More Oracle Issues:
Parameters must be in the same order; unless you set Command.bindByNames = true (requires direct reference)
Parameter names cannot use reserved words.
Orcale does not like the bind identifiers in the parameter names.

27-Jan-2013
Still working on Optimistic Concurrency support, Sql Server and Oracle working so far.

28-Jan-2013
Optimistic Concurrency support working for My Sql. You must be using version 5.6>
Also the managment client does not seem to allow you create the new TimeStamp with millisecond support.
It must be done via script.

Need to change sql builders to return id as an output parameter.

Added a test project for Sql Server CE, may require some work. DateTime2, Scope_Indentity, and batch statements does not seem to be supported.
MARS Support may not be supported also. Will probably put this on the back burner for a while.

29-Jan-2013
Code analysis clean-ups. Prep for deployment.