执行原生SQL语句

# 执行SQL非查询语句
>d dbCtx.Database.ExecuteSqlInterpolated
ctx.Database.ExecuteSqlInterpolatedAsync

```java
using TestDbContext ctx = new TestDbContext();
Console.WriteLine("请输入最低价格");
double price = double.Parse(Console.ReadLine());
Console.WriteLine("请输入姓名");
string aName = Console.ReadLine();
int rows = await ctx.Database.ExecuteSqlInterpolatedAsync(@$"
	insert into T_Books (Title,PubTime,Price,AuthorName)
	select Title, PubTime, Price,{aName} from T_Books where Price>{price}");
            
//参数是FormattableString类型，会自动把{aName}、{price}翻译为@p0,@p1

```

# 实体类SQL查询语句
>d FromSqlInterpolated
```java
using TestDbContext ctx = new TestDbContext();
int year = int.Parse(Console.ReadLine());
//参数是同样是FormattableString类型，会自动把{year}翻译为@p0
IQueryable<Book> books = ctx.Books.FromSqlInterpolated(@$"select * from T_Books
		where DatePart(year,PubTime)>{year} order by newid()");
foreach (Book b in books)
{
	Console.WriteLine(b.Title);
}
//返回值是IQueryable类型，可以复用

```

FromSqlInterpolated的局限下：

- SQL查询必须返回实体类型对应数据库表的所有列
- 查询结果集中的列明必须与属性映射到列明匹配
- 只能进行单表查询，不能使用过Join进行关联查询，但是可以在查询后面使用Include方法进行查询