EvaFrameWork.Sql is a simple object-database mapper for .NET

Start Guide

Structuring the Application

Document

All Forms are Perfectly Working.

Project & Practice

Scalable on Devices.

EvaFrameWork.Sql Works with SQL Server, MySQL, Oracle, SQLite.

It supports repository, cache, generate code and schema migrations. committed to improving development efficiency, reduce the amount of code, even read and write multiple databases at the same time.

Download via NuGet.org




Structuring the Application

Asp NetCore Mvc and autofac

var builder = new ContainerBuilder();

IEva IEva = new Eva(DataBaseType.SqlServer, connectionString);

//Global primary Key config
IEva.SetGlobalKey(new string[] {"Id"});

//Global filter config
IEva.AddFilter("IsDelete", "0", typeof(int));

//Enable data cache
IEva.SetCache(true);

//Set type Chapter and ChapterType to cache container
IEva.AddCache(new CacheSet(x => x.Id, true).Add(x => x.Code).Add(x => x.Title).Add(x=>x.Contents));
IEva.AddCache(new CacheSet(x => x.Code, true).Add(x => x.Name));

//Init EvaFramework and get a Ievacontext
IEva.Init(out IEvaContext _evaContext, out IEvaCache IEvaCache);

//Register _evaContext to autofac container
builder.Register(x => _evaContext).As().InstancePerLifetimeScope();

//Enable EvaFramework Repository, register Repository<> to autofac container
builder.RegisterGeneric(typeof(Repository<>)).As(typeof(IRepository<>))
.InstancePerLifetimeScope();

//other type Register .....

//Return Autofac container
builder.Populate(services);
_container = builder.Build();
_autofacServiceProvider = new AutofacServiceProvider(_container);

Winform Application

private IEvaContext _sqlServerContext;
private IEvaCache _sqlCache;
//Create "InitEvaForSqlServer method
private void InitEvaForSqlServer(string defaultConnection)
{
  IEva IEva = new Eva(DataBaseType.SqlServer, defaultConnection);

  //Global primary Key config
  IEva.SetGlobalKey(new string[] {"Id"})

  //Global filter config
  IEva.AddFilter("IsDelete", "0", typeof(int));

  //Enable data cache
  IEva.SetCache(true);

  //Set type Chapter and ChapterType to cache container
  IEva.AddCache(new CacheSet(x => x.Id, true).Add(x => x.Code).Add(x => x.Title).Add(x=>x.Contents));
  IEva.AddCache(new CacheSet(x => x.Code, true).Add(x => x.Name));

  //Init EvaFramework and get a Ievacontext
  IEva.Init(out IEvaContext _evaContext, out IEvaCache IEvaCache);

  //Set context and cache to global variable
   this._sqlServerContext = _evaContext;
   this._sqlCache = EvaCache;
}

//Then call it from your "Form_Load" or "Form_Shown"
private void MainForm_Load(object sender, EventArgs e)
{
     this.InitEvaForSqlServer(connectionString);
      ...
}

Application & Tool

Paris
Web Application Demo

Asp NetCore Mvc6.0 + Autofac + EvaFrameWork.Sql

Read more
Paris
Course management system

The New YouTube Economy unfolds itself

Read more