摘要:select real_name as 姓名, a.phone as 手机号,id_card_no as 身份证号,id_card_type as 证件类型, a.address as 地址,f.num as 证件数量, f.card as 内含证件类型, c.name as 村小组名称, a.cr
阅读全文
posted @ 2021-11-30 15:02
|
|||
随笔分类 - Linq To Sql
摘要:select real_name as 姓名, a.phone as 手机号,id_card_no as 身份证号,id_card_type as 证件类型, a.address as 地址,f.num as 证件数量, f.card as 内含证件类型, c.name as 村小组名称, a.cr
阅读全文
posted @ 2021-11-30 15:02
摘要:UPDATE orders LEFT JOIN freports ON freports.order_id = orders.id set orders.finish_at = freports.created_at where orders.id in(1,2,3)
阅读全文
posted @ 2021-01-14 11:10
摘要:select count(id),sum(Price) from [T_AddPrice] as a where (select sum(Price) from [T_AddPrice] as b where a.id<=b.id)<1000 --order by id
阅读全文
posted @ 2019-01-29 14:15
摘要:其实只要明白 LINQ查询操作符的 Distinct、Union、Concat、Intersect、Except、Skip、Take、SkipWhile、TakeWhile、Single、SingleOrDefault、Reverse、SelectMany,Aggregate()(这个挺偏的,具体意
阅读全文
posted @ 2018-06-01 14:00
摘要:Lambda表达式 "Lambda表达式"是一个匿名函数,是一种高效的类似于函数式编程的表达式,Lambda简化了开发中需要编写的代码量。它可以包含表达式和语句,并且可用于创建委托或表达式目录树类型,支持带有可绑定到委托或表达式树的输入参数的内联表达式。所有Lambda表达式都使用Lambda运算符
阅读全文
posted @ 2017-03-06 16:58
|
|||