Gester.Lin - 博客园

2015年10月10日

摘要： Joins in sql serverAdvanced or intelligent joins in sql serverSelf join in sql serverDifferent ways to replace NULL in sql server 阅读全文

posted @ 2015-10-10 11:55 Gester.Lin 阅读(402) 评论(0) 推荐(0)

Part 6 Group by in sql server

摘要：阅读全文

posted @ 2015-10-10 11:55 Gester.Lin 阅读(145) 评论(0) 推荐(0)

Part 5 Select statement in sql server

摘要： Select specific or all columnsselect * from 表名select * from Studentselect 列名，列名... from 表名select name,age,email from StudentDistinct rowsselect distin... 阅读全文

posted @ 2015-10-10 11:55 Gester.Lin 阅读(192) 评论(0) 推荐(0)

Part 9 Union and union all in sql server

摘要： Union and union all in sql server 阅读全文

posted @ 2015-10-10 11:54 Gester.Lin 阅读(167) 评论(0) 推荐(0)

Part 8 Coalesce function in sql server

摘要：阅读全文

posted @ 2015-10-10 11:54 Gester.Lin 阅读(140) 评论(0) 推荐(0)

2015年10月5日

Part 4 using entity framework

摘要： Step1: Install entity framework using nuget package manager.Step2: Add a class file to the Models folder.(class name must equal connection string name... 阅读全文

posted @ 2015-10-05 20:19 Gester.Lin 阅读(334) 评论(0) 推荐(1)

Part 3 ViewData and ViewBag in mvc

摘要： ViewBag and ViewData is a mechanism(机制) to pass data from controller to view.We use '@' symbol(符号) to switch between html and C# code.Both ViewData an... 阅读全文

posted @ 2015-10-05 19:28 Gester.Lin 阅读(234) 评论(0) 推荐(1)

Part 2 How are the URL's mapped to Controller Action Methods?

摘要： Part 2 How are the URL's mapped to Controller Action Methods?The answer is ASP.NET Routing.Notice that in Global.asax we have RegisterRoutes().and pre... 阅读全文

posted @ 2015-10-05 17:36 Gester.Lin 阅读(209) 评论(0) 推荐(1)

Part 1 some difference from asp.net to asp.net mvc4

摘要： Part 1 some difference from asp.net to asp.net mvc4In MVC URL's are mapped to controller Action MethodsIn a WebForms URL's are mapped to Physical File... 阅读全文

posted @ 2015-10-05 17:35 Gester.Lin 阅读(205) 评论(2) 推荐(1)

2015年9月15日

Part 18 Indexes in sql server

摘要： Indexes in sql serverClustered and nonclustered indexes in sql serverUnique and Non Unique Indexes in sql serverAdvantages and disadvantages of indexe... 阅读全文

posted @ 2015-09-15 22:19 Gester.Lin 阅读(162) 评论(0) 推荐(0)

For Freedom

Just Do It. Just Rock It. Just Love It.

公告