# ExpressionTurn

**Repository Path**: azthinker/ExpressionTurn

## Basic Information

- **Project Name**: ExpressionTurn
- **Description**: Expression To Sql Statement 表达式转SQL语句
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 9
- **Forks**: 0
- **Created**: 2018-09-19
- **Last Updated**: 2025-08-01

## Categories & Tags

**Categories**: database-dev

**Tags**: None

## README

Lambda表达式转SQL语句类库
=
一、可以达到的功能
-
本功能类库主要提供给代码中使用Lambda表达式，后需转成SQL的条件语句这一需求

二、不能做的
-
1、本类库不能解析Linq语句

2、不能解析SQL中的Select部分
  
例1：
-
```C#
  class A
{
    public Int16 Id { get; set; }
    public string name { get; set; }
    public string sex { get; set; }
}
```
```C#
AtkExpConditions<A> expa = new AtkExpConditions<A>();
expa.AddAndWhere(s => s.Id == 123 && s.name.Contains("a"), AtkAlias.a2);
expa.UpdateFields(s => new { s.Id, s.sex }, AtkAlias.a2);
``` 
结果生成下列两个语句：<br>
1、Where (([a2].[Id] = 123) and ([a2].[name] LIKE '%' + 'a' + '%'))<br>
2、[a2].[Id] = @Id,[a2].[sexA] = @sex<br>


例2：
-
```c#
    // 当需要多子句拼接时，自动合并成合适的子句，如 Where ，不会出现多个“where”关键词。
    // When multiple clauses are required to be spliced, 
    // they are automatically merged into appropriate clauses, 
    // such as Where, without multiple "Where" keywords.
    AtkExpConditions<A> expa2 = new AtkExpConditions<A>();

    if (1==1)
    {
	    expa2.AddAndWhere(s => s.Id == 123);
    }

    if (2==2)
    {
	    expa2.AddAndWhere(s => s.name.Contains("a"));
    }
```

结果生成下列两个语句：<br>
   Where ([a0].[Id] = 123) And ([a0].[name] LIKE '%' + 'a' + '%')<br>
   
   
 QQ:344709752