public BatchService(IConfigurationRoot config, ILogger logger) { var baseUrl = config["SomeConfigItem:BaseUrl"]; var token = config["SomeConfigItem:Token"]; _baseUrl = baseUrl; _token = token; _logger = logger; //以下可以2選一,物件屬性和資料表的對映 //SqlMapper.SetTypeMap(typeof(UserInfo), new ColumnTypeMapper(typeof(UserInfo))); ColumnTypeMapper.RegisterForTypes(typeof(UserInfo), typeof(UserInfo)); }
static SqlConnectionExtensions() { //Initialize (column)mappings for all resultobjects //TODO: this is kinda hairy; we need a better way to get the classes that need to be mapped. Maybe make // them share a common ("empty") baseclass or put them in a separate (sub)namespace? ColumnTypeMapper.RegisterForTypes( Assembly.GetExecutingAssembly() .GetTypes() .Where(t => t.IsClass && t.IsPublic && !IsStatic(t) && !typeof(Attribute).Equals(t.BaseType)) .ToArray() ); }
public static void Init() { var assemblies = new[] { "PokemonGenerator", /* Add additional Dapper-able assemblies here */ }; var types = new List <Type>(); foreach (var assembly in assemblies) { types.AddRange(Assembly.Load(assembly).GetTypes() .Where(t => t.IsClass)); } ColumnTypeMapper.RegisterForTypes(types.ToArray()); }