笑东风

摘要： Encoding gb = Encoding.GetEncoding("GB2312"); byte[] bytes = System.IO.File.ReadAllBytes("gb.txt"); string str = gb.GetString(bytes); Console.WriteLine(str); byte[] utfBytes = Encoding.UTF8.GetBytes(str); System.IO.File.WriteAllBytes... 阅读全文

摘要： //添加StaticFileWriteFilterAttribute public class StaticFileWriteFilterAttribute : FilterAttribute, IResultFilter { public void OnResultExecuted(ResultExecutedContext filterContext) { } public void OnResultExecuting(ResultExecutingContext filterContext) { ... 阅读全文

摘要： 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 阅读全文

摘要： public class CheckLoginAttribute : ActionFilterAttribute { public CheckLoginAttribute() { } public override void OnActionExecuting(ActionExecutingContext filterContext) { if (filterContext.HttpContext.Session["User"] == null) { ... 阅读全文

摘要： 1 [STAThread] 2 static void Main() 3 { 4 Application.ThreadException += new System.Threading.ThreadExceptionEventHandler(Application_ThreadException); 5 AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledEx... 阅读全文

摘要： USE tempdbGOCREATE TABLE Table1( ID INT IDENTITY(1,1) NOT NULL, UserID INT NOT NULL)GOINSERT INTO Table1(UserID)SELECT 1UNION ALLSELECT 1UNION ALLSELECT 3UNION ALLSELECT 4UNION ALLSELECT 5GOSELECTUserID,ROW_NUMBER()OVER(ORDER BY UserID) AS RowNumberID,RANK()OVER(ORDER BY UserID) AS RankID,DENS... 阅读全文

摘要： --======================================================================================================================--Step 1--======================================================================================================================--================================================== 阅读全文

摘要： After 触发器将在处理触发操作（Insert、Update 或 Delete）、Instead Of 触发器和约束之后激发。Instead Of是将在处理约束前激发，以替代触发操作。After触发器在触发时操作已影响表中数据，Instead of 触发器触发时操作未影响数据表中数据。不存在DDL 类型的Instead of 触发器，在DDL触发器创建时可以使用Instead表和Deleted表，但是会引发运行时异常。可以在存储过程或触发器中执行 ROLLBACK TRANSACTION 或 COMMIT TRANSACTION Transact-SQL 语句，但这样可能会导致错误。（MSD 阅读全文