一.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);
}
相关博客:
http://www.cnblogs.com/lyj/archive/2008/03/25/1119671.html