C#知识的扩展(EF、Linq、lambda、MVC、jquery)

最新推荐文章于 2024-07-15 10:49:13 发布

放开那段代码让我来

最新推荐文章于 2024-07-15 10:49:13 发布

阅读量692

点赞数

分类专栏： Linq 文章标签： linq

Linq 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

一.EF相关技术文档：/

http://www.entityframeworktutorial.net/

点击打开链接

https://msdn.microsoft.com/en-us/library/aa937723(v=vs.113).aspx

MVC经典：

张子阳mvc：http://www.tracefact.net
ASP.NETMVC:https://www.asp.net/mvc/overview

MVC入门

http://www.cnblogs.com/youring2/p/3192682.html

一、博客园LINQ
http://kb.cnblogs.com/zt/linq/

http://www.cnblogs.com/qixuejia/p/7284697.html

一步一步学Linq

http://kb.cnblogs.com/page/42691/

二、lambda表达式博客园：：：
http://www.cnblogs.com/knowledgesea/p/3163725.html

三、博客园MVC学习：：：：
http://kb.cnblogs.com/zt/mvc/

邹琼俊mvc博客

http://www.cnblogs.com/jiekzou/ 代表作品：ASP.NET MVC企业级实战
 http://www.cnblogs.com/jiekzou/p/4772273.html

四、博客园jquery学习：：

http://kb.cnblogs.com/zt/jquery/

Linq 转换成SQL
http://www.linqpad.net/
SQL 转成Linq工具
http://www.sqltolinq.com/downloads

Linq to SQL学习：
http://www.cnblogs.com/yukaizhao/archive/2010/05/13/linq_to_sql_1.html

MVC5+EF6教程

http://www.cnblogs.com/miro/p/4053473.html

LINQ之路系列博客导航

http://www.cnblogs.com/lifepoem/archive/2011/12/16/2288017.html

//C#lambda表达式关键字：
//Select()/ SelectMany()/ Skip()/ SkipWhile()/ Take()/ ToList()/ Where()/ GroupBy()/ OrderBy() / First()
//Linq语法：
https://docs.microsoft.com/zh-cn/dotnet/csharp/programming-guide/concepts/linq/basic-linq-query-operations
//C#lambda
https://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

五、google浏览器调试使用：

http://www.cnblogs.com/starof/p/5404641.html

T-SQL语句：
select  ... 
from dbo.LbtProjectInfo
where  TestType=1
group by  ...
having ContactStates=2
order by ID  desc

================================

1.linq:

ToArray：将序列转换为数组

var q =
    from c in db.Customers
    where c.City == "London"
    select c;
Customer[] qArray = q.ToArray();q =
    from c in db.Customers
    where c.City == "London"
    select c;
Customer[] qArray = q.ToArray();

ToList：将序列转换为泛型列表

var q =
    from e in db.Employees
    where e.HireDate >= new DateTime(1994, 1, 1)
    select e;
List<Employee> qList = q.ToList();q =
    from e in db.Employees
    where e.HireDate >= new DateTime(1994, 1, 1)
    select e;
List<Employee> qList = q.ToList();

ToDictionary：将序列转化为字典

var q =
    from p in db.Products
    where p.UnitsInStock <= p.ReorderLevel && !p.Discontinued
    select p;
Dictionary<int, Product> qDictionary =
    q.ToDictionary(p => p.ProductID);
foreach (int key in qDictionary.Keys)
{
    Console.WriteLine(key);
}q =
    from p in db.Products
    where p.UnitsInStock <= p.ReorderLevel && !p.Discontinued
    select p;
Dictionary<int, Product> qDictionary =
    q.ToDictionary(p => p.ProductID);
foreach (int key in qDictionary.Keys)
{
    Console.WriteLine(key);
}