Suid.OpenToolbox.Data.Abstractions 6.0.0

Welcome to Open Toolbox Data Access Layer's documentation

Open Toolbox Data Access Layer is a .Net standard library that make easier and more readeable the use of entity framework. Library provides commands to read, create, update or delete entries in databases command. Open Toolbox Data Access Layer is write in .Net Standard 2.1, see Table of Compatibility for more information.

Documentation

What Data.Abstractions is made for

In order to use other librairies in Suid.OpenToolbox solution, class that represents an element in a database have to implement an interface. Please check below what to use in with situation.

Class representing a table

If the class your currently creating is the representation of a table, this class should implement the interface Suid.OpenToolbox.Data.Abstractions.Generics.IEntity depending of the number of primary keys.

One primary key

Let's take as an exemple a table called Entity with one integer primary key, it should be :

using Suid.OpenToolbox.Data.Abstractions.Generics;

/// <inheritdoc />
public class Entity : IEntity<int>
{
	/// <inheritdoc/>
	public int Id { get; set; }

	...
}

Two or more primary keys

Let's take as an exemple a table called Entity with dual columns primary key, it should be :

using Suid.OpenToolbox.Data.Abstractions.Generics;

/// <inheritdoc />
public class Entity : IEntity<int, string>
{
	/// <inheritdoc/>
	public int IdOne { get; set; }

	/// <inheritdoc/>
	public string IdTwo { get; set; }
	...
}

How to use my own columns name in case of multiple columns primary key ?

using Suid.OpenToolbox.Data.Abstractions.Generics;

/// <inheritdoc />
public class Entity : IEntity<int, string>
{
	/// <inheritdoc/>
	public int IdOne
	{
		get => this.MyFirstColumnId;
		set
		{
			value = this.MyFirstColumnId;
		}
	}

	/// <inheritdoc/>
	public string IdTwo
	{
		get => this.MySecondColumnId;
		set
		{
			value = this.MySecondColumnId;
		}
	}

	/// <summary>
	/// My own named first column id.
	/// </summary>
	public int MyFirstColumnId { get; set; }

	/// <summary>
	/// My own named second column id.
	/// </summary>
	public string MySecondColumnId { get; set; }
	...
}