不知園子裡有多少人在使用SubSonic,去年7月份開始接觸SubSonic,隨即在剛啟動的新項目中啟用,放棄了原計劃使用iBATIS.NET 的方案。不是說iBATIS.NET 不好,而是我覺得SubSonic比iBATIS.NET在更勝任短平快的WEB應用,SubSonic比iBATIS.NET省去了一大堆的映射設定檔,在資料庫變更時,也無需再去維護煩瑣的配置,那個叫省心呀~~~SubSonic的發起人Rob Conery已經加入了MS ASP.NET
SQL語句的並集UNION,交集JOIN(內串連,外串連),交叉串連(CROSS JOIN笛卡爾積),差集(NOT IN)1.a. 並集UNIONSELECT column1, column2 FROM table1UNIONSELECT column1, column2 FROM table2b. 交集JOINSELECT * FROM table1 AS a JOIN table2 b ON a.name=b.namec. 差集NOT INSELECT * FROM table1
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--以下示範ip地址加密,ip欄位類型為binaryselect * from xl_whitelistdelete xl_whitelistinsert into xl_whitelist (ip) values(cast('lijian' as binary(50)))select cast(ip
int recordsAffected = new Update(Northwind.Product.Schema).Set(“UnitPrice”).EqualTo(100).Where(“productid”).IsEqualTo(1).Execute(); int records = new Update(Northwind.Product.Schema) .SetExpression(“UnitPrice”).EqualTo(“UnitPrice * 3″) .Where(“
.netTiers is not free. It used to be free, but then Eric J. Smith changed his pricing model and yanked the free version out from under the community that made codesmith a booming product. In my opinion, codesmith had the perfect model. There was a