BlackHole.Core.ORM 6.0.3

BlackHole-Core-ORM

A fully automated, very easy to use and setup, with many new features, Object Relational Mapping Library, for .Net Core 6 and 7. Using Custom Data Providers that are 3x times faster than EF Core and Dapper. Many interfaces for easy Reading and Writing Data. Extention Methods for Joining any tables. It Supports SQL SERVER, MYSQL, POSTGRESQL, ORACLE and SQLITE.

Version 6.0.3

Changes:

• Added Schema Support for Sql Helper functions
• Added Max and Min Date Sql Helper functions
• Fixed the descriptions of the methods

Example:

-Find an Example Project here ⇒ BlackHole Example

Tutorial Video:

-Complete Tutorial ⇒ YouTube Tutorial

Documentation:

-Find Online Documentation here ⇒ BlackHole Documentation

Command Line Interface dotnet tool:

-Find BlackHole.Core.Cli here ⇒ Nuget

Quick Start:

• In Your project install Black.Hole.ORM from nuget

• In your Program.cs add 'using BlackHole.Configuration' Add the following line into your IServiceCollection ⇒ services.SuperNova(settings ⇒ settings.IsDeveloperMode(devmode == "dev").AddDatabase(connection ⇒ connection.UseOracle(connectionString)))

• Create some Entities in any folder that Inherit from the class 'BlackHoleEntity<int>' for Entities that are using Integer as Id, or 'BlackHoleEntity<Guid>' for Entities that are using Guid as Id or 'BlackHoleEntity<string>' for Entities that are using SHA1 hash as Id. (using BlackHole.Entities)

• Add properties on your Entities except the Id property that already exists in the BlackHoleEntity class.

• Add Attributes to the properties of your Entities' '[ForeignKey(typeof(Entity), nullability)]' , '[NotNullable]' and '[VarCharSize(int)]'

  • You can also use '[UseActivator]' attribute on your Entity, to take advantage of the 'IsActive' column in case you need to keep the data after delete.

• Make your services Inherit from 'BlackHoleScoped' or 'BlackHoleSingleton' or 'BlackHoleTransient' so they will be automatically registered on the Startup without needing services.Add(<>). (using BlackHole.Services)

• Last step , go to your services or your controllers and add the Interfaces for the DataProviders ⇒ private readonly IBHDataProvider<Entity,IdType> _entityService; Example: IBHDataProvider<Customer,Guid> _customerService; (using BlackHole.Core)

• For custom queries and commands, use the IBHConnection Interface that is already Injected with Dependency Injection.

• Done! You are ready to use all the functionality of the Data Providers in your services.

• there are descriptions on the methods of what they do

• The Ids are created automatically on Insert and they get returned.

• The cascade on Foreign keys is automatic and it depends on the Nullability of the column

Visit Mikarsoft Official Webpage for more Information.