# DbFrame

**Repository Path**: andyshao/DbFrame

## Basic Information

- **Project Name**: DbFrame
- **Description**: 生产 SQL 语句 让 dapper 执行的 ORM
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 6
- **Created**: 2019-02-27
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# DbFrame

#### 介绍


```
DbContextSqlServer.SetDefaultConnectionString("Server=.;Database=AppDB;User ID=sa;Password=123456;");

var db = new DbContextSqlServer();

var guids = new List<Guid>() { Guid.NewGuid(), Guid.NewGuid(), Guid.NewGuid() };

var _Iquery = db.Query<Member>()
                .Where(item => item.Member_ID.In(guids))// 语法 IN(1,2,3)
                .OrderByDesc(item => item.Member_CreateTime);
            //.OrderBy(item => item.Member_CreateTime);
            //.OrderBy(member => new { desc = member.Member_CreateTime });//.Top(1).ToList();

            //分页
            var _Meber_List = _Iquery.TakePage(1, 20).ToList<dynamic>();

            //总数
            //var _Count = _Iquery.Count();

            //var _Max = _Iquery.Max(w => w.Member_CreateTime);

            //var _Min = _Iquery.Min(w => w.Member_CreateTime);

            //var _Sum = _Iquery.Sum(w => w.Member_Phone);

            var _Member = db.Find<Member>(w => w.Member_ID == "9a604aa2-9ae6-4a2f-8ddb-d9e0289ead9e".ToGuid());

            var _Sql = db.Query<Member>()
                         .Join<Sys_User>((a, b) => a.Member_UserID == b.User_ID)
                         .Where((a, b) => a.Member_Sex == "男")
                         .Select((a, b) => a)//new { a.Member_Name, b.User_LoginName })
                         .ToList<dynamic>();

            var _Member_Frist = db.Query<Member>()
                          .Join<Sys_User>((a, b) => a.Member_UserID == b.User_ID)
                          .Where((a, b) => a.Member_Sex == "男")
                          .Select((a, b) => new { a, b.User_LoginName })
                          .Frist<dynamic>();

            var _Member_Frist_0 = db.Query<Member>()
                      .Join<Sys_User>((a, b) => a.Member_UserID == b.User_ID)
                      .Where((a, b) => a.Member_Sex == "男")
                      .Select((a, b) => a.Member_Name)
                      .Frist<dynamic>();

            var filed = "Member_Name";

            var _Member_Frist_1 = db.Query<Member>()
                         .Join<Sys_User>((a, b) => a.Member_UserID == b.User_ID)
                         .Where((a, b) => a.Member_Sex == "男")
                         .Select((a, b) => filed)
                         .Frist<dynamic>();

            foreach (var item in _Sql)
            {
                var a = item.Member_Name;
            }

            db.Commit(() =>
            {


                /**int  自增**/
                //var _int_tab = new int_tab();
                //_int_tab.name = "hzy" + DateTime.Now;

                //_int_tab.id = db.Insert<int_tab>(_int_tab).ToInt32();

                /*** guid 主键 ***/

                for (int i = 0; i < 100; i++)
                {
                    _Member = new Member();
                    _Member.Member_Birthday = DateTime.Now;
                    _Member.Member_Introduce = "111";
                    _Member.Member_Name = "wjf" + DateTime.Now;
                    _Member.Member_Num = "1";
                    _Member.Member_Phone = 123123123;
                    _Member.Member_Sex = "男";
                    _Member.Member_ID = db.Insert<Member>(_Member).ToGuid();

                }

                var iquery = db.Query<Member>()
                      .Where(a => a.Member_Sex.Contains("男"))
                      .Select(a => new { a.Member_Name })
                      .ToList<dynamic>();

                var list = db.QueryBySql<Member>("select * from Member with(nolock)");

                throw new Exception("123");
            });

            //db.DeleteById<Member>(_Member.Member_ID);
```


#### 使用说明

1. xxxx
2. xxxx
3. xxxx

#### 参与贡献

1. Fork 本仓库
2. 新建 Feat_xxx 分支
3. 提交代码
4. 新建 Pull Request


#### 码云特技

1. 使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2. 码云官方博客 [blog.gitee.com](https://blog.gitee.com)
3. 你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解码云上的优秀开源项目
4. [GVP](https://gitee.com/gvp) 全称是码云最有价值开源项目，是码云综合评定出的优秀开源项目
5. 码云官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6. 码云封面人物是一档用来展示码云会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)