# DbFrame

**Repository Path**: fremwork/DbFrame

## Basic Information

- **Project Name**: DbFrame
- **Description**: 数据访问框架 ORM 基于 Dapper
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2018-06-30
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# DbFrame

#### 项目介绍
数据访问框架 ORM 基于 Dapper 使用Lambda表达式生产Sql语句


#### 基本语法
           
```
DbFrameConfig.ConnectionString = "Server=.;Database=AppDB;User ID=sa;Password=123456;";
var li = new List<SQL>();
var db = new DBContext();

var query = db
    .Query<MemberM, Sys_UserM>((a, b) => new { a.Member_Name, a.Member_ID, b.User_Name, _ukid = a.Member_ID })
    .LeftJoin((a, b) => a.Member_UserID == b.User_ID, "b")
    .Where((a, b) => a.Member_Name == "测试")
    .ToList<MemberM>();

for (int i = 0; i < 10; i++)
{
    var id = db.Add<Sys_UserM>(new Sys_UserM()
    {
        User_Email = i + "test@qq.com",
        User_LoginName = i + "hzyNew",
        User_Name = i + "hzyTestNew",
        User_Pwd = i + "123"
    }, li);

    if (!db.Edit<Sys_UserM>(() => new Sys_UserM
        {
            User_Name = "修改过" + i + "hzyTestNew"
        }, w => w.User_ID == id.GetGuid(), li))
    {
        Console.WriteLine("错误！");
    }
}

db.Delete<Sys_UserM>(w => w.User_CreateTime > DateTime.Now.AddDays(-1), li);

if (!db.Commit(li))
{
    Console.WriteLine("事务提交失败！");
}

var _Sys_UserM = new Sys_UserM();
_Sys_UserM.User_Email = "1123@QQ.COM";
_Sys_UserM.User_LoginName = "admin";
_Sys_UserM.User_Name = "hzy";
_Sys_UserM.User_Pwd = "123";

//验证实体
if (db.CheckModel(_Sys_UserM))
{
    db.Add(_Sys_UserM);
}
else
{
    Console.WriteLine(db.ErrorMessge);
}

var Count = 0;
var Query = db
    .Query<Sys_UserM>((a) => new { a.User_LoginName, a.User_Name, a.User_Email, a.User_Pwd, a.User_CreateTime, a.User_ID })
    .Where((a) => a.User_LoginName == "user");

var dt = db.FindPaging(Query.ToSQL(), 1, 20, out Count, Query.GetSqlParameters());//分页查询
```