笑东风

摘要：Link:http://visualstudiogallery.msdn.microsoft.com/72a60b14-1581-4b9b-89f2-846072eff19dDesc:When right-clicking on a C# project, the following context menu functions are supported:Reverse Engineer Code First - Generates POCO classes, derived DbContext and Code First mapping for an existing database. 阅读全文

摘要：Env:Client: WinForm(Net Framework 2.0)Server:Web Service(Net Framework 4.0)Problem:Client use proxy to invoke a simple method in web services, this methodonly take a fewmilliseconds but the first invoke maytake more than 10 seconds.Reason:The defult proxy was enable by default (if the element is not 阅读全文

摘要：在TSQL中，查询语句编译时并不为变量赋值(SET OR SELECT Operation)，即变量赋值在编译完成，语句执行时才执行赋值操作，因此查询优化器不一定能为查询语句生成一个合适的执行计划ex：DECLARE @Id INT =100;SELECT * FROM dbo.UsersWHERE UserId>@Id可以使用以下几种方式修改：--=====================================================DECLARE @Id INT =100;SELECT * FROM dbo.UsersWHERE UserId>@IdOPTIO 阅读全文