#如何做个好用的数据库访问类
数据库访问组件是应用系统开发中的基础组件,在用过SQLHelper、EnterpriseLibrary、NHibernate、EntityFramework之后,我开始思考什么样的数据库访问组件适合互联网应用开发。
- 自动释放数据库连接及相关资源
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Text; | |
namespace ChineseNumberParser | |
{ | |
internal class ChineseNumber | |
{ | |
private int value; |
@echo off | |
SET st3Path=C:\Program Files\Sublime Text 3\sublime_text.exe | |
rem add it for all file types | |
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3" /t REG_SZ /v "" /d "Open with Sublime Text 3" /f | |
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3" /t REG_EXPAND_SZ /v "Icon" /d "%st3Path%,0" /f | |
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3\command" /t REG_SZ /v "" /d "%st3Path% \"%%1\"" /f | |
rem add it for folders | |
@reg add "HKEY_CLASSES_ROOT\Folder\shell\Open with Sublime Text 3" /t REG_SZ /v "" /d "Open with Sublime Text 3" /f |
public class MyDBTestCaseBase extends DBTestCase { | |
protected static ApplicationContext ctx; | |
static { | |
// init ctx | |
} | |
@Override | |
protected IDataSet getDataSet() throws Exception { |
Dictionary<>
will take adventage of key's equality comparer when call Add
, Remove
, Contains
and other methods. If we don't pass a comparer when declaring dictionary, it will use the default comparer. The default comparer will use key's Equals
method to compare. So we have two solutions:
MyKeyEqualityComparer
and override its Equals(TKey x, TKey y)
method.EqualityComparer.Default
and override MyKey
's Equals
method.