Bara Document

Bara

Codacy	Appveyor	NuGet

Bara is a .Net library for Orm. Bara provides quick access to DataBase. Also it is a cross-platform orm which is written by .net Standard version 1.4 . You Can use it on .net Framwork platform or .net Core platform with Any type DataBase which Dapper Support.

Features

• Using Dapper for DataMapping and DataAccess.
• Using Xml Config and Manage your sql like Ibatis.
• Hot Update Sql when you changed your sql sentence.

Installing

Just install the Bara NuGet package:

PM> Install-Package Bara

If your want Bara Extension.(A collection of commonly used methods already included)

PM> Install-Package Bara.DataAccess

How To Use After Intalled

1.Add BaraMapConfig.xml To Root Path.

• Config whether the config need Watched.It will be update when setting true.
• Config DataBase ConnectString
• Split Writen DB and Read DB. Specify each Database Weight which indicate the Access probability.
• Specify the ParameterPrefix（MSSQL:'@',Mysql:'#'...）
• Config your Maps which your sql in.

<?xml version="1.0" encoding="utf-8" ?>
<BaraMapConfig xmlns="https://github.com/RocherKong/Bara/schemas/BaraMapConfig.xsd">
  <Settings
    IsWatchConfigFile="true"
  />
  <Database>
    <DbProvider Name="SqlClientFactory" ParameterPrefix="@" Type="System.Data.SqlClient.SqlClientFactory,System.Data.SqlClient"/>
    <Write Name="WriteDB" ConnectionString="Data Source=.;database=GoodJob;uid=sa;pwd=App1234"/>
    <Read Name="ReadDB-0" ConnectionString="Data Source=.;database=GoodJob;uid=sa;pwd=App1234" Weight="50"/>
    <Read Name="ReadDB-1" ConnectionString="Data Source=.;database=GoodJob;uid=sa;pwd=App1234" Weight="50"/>
  </Database>
  <BaraMaps>
    <BaraMap Path="Maps/" Type="Directory"></BaraMap>
  </BaraMaps>
</BaraMapConfig>

2.Config BaraMap Xml Files(eg:T_Test.xml in Root-Folder Maps)

3.Register To DI in Startup.cs

 services.AddSingleton<IBaraMapper>(MapperContainer.Instance.GetBaraMapper());

4.Use Any Where

4.1 GetEntity

           var mapper = new BaraMapper();
           var result = mapper.QuerySingle<T_Test>(new Core.Context.RequestContext
            {
                SqlId = "GetEntity",
                Scope = "T_Test",
                Request = new { Id = 1 }
            });

4.2 QueryList

             var list= mapper.Query<T_Test>(new Core.Context.RequestContext
                {
                    SqlId="GetList",
                    Scope="T_Test",
                });

Next Step

• 1.Test
• 2.Test Compare
• 3.redis cache
• 4.zookeeper(options)
• 5.add Doc
• 6.Release