# NORM

**Repository Path**: sqlorm/NORM

## Basic Information

- **Project Name**: NORM
- **Description**: 数据库持久层，SQL脚本生成器
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: https://git.oschina.net/sqlorm/NORM
- **GVP Project**: No

## Statistics

- **Stars**: 30
- **Forks**: 12
- **Created**: 2016-01-15
- **Last Updated**: 2024-04-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

数据库持久层，SQL脚本生成器

示例代码：


```
PageLimit pager = new PageLimit();
pager.PageIndex = 2;
pager.PageSize = 20;

Models.BearingPara model1 = new Models.BearingPara();
Models.BearingFactory model2 = new Models.BearingFactory();

OQL oql = OQL.From(model1)
          .Join(model2).ON(model1.FactoryID, model2.FactoryID)
          .Where(model1.FactoryID, "=", 1)
          .And(model2.Remark, "IS", "NULL")
          .Select(() => new
                    {
                        model1.ModelID,
                        model1.ModelName,
                        model1.NB,
                        model1.BPFI,
                        model2.FactoryName,
                        model2.Remark
                    }).End;

var data = EntityQuery<T>.Instance.QueryToTable(oql, pager, db);                
```