static void Main(string[] args)
{
try
{
DapperConfiguration.Initialize();
ConnectionProvider provider = new ConnectionProvider();
UserAccountDapper dapper = new UserAccountDapper();
// UserAccountBroker userDataBroker = new UserAccountBroker(provider);
//UserAccount user = userDataBroker.GetUserAccount("florian", "pwd");
UserAccount user = null;
IEnumerable <UserAccount> accounts = dapper.GetAllContact(provider.GetConnection(), 1);
user = dapper.GetUserAccount(provider.GetConnection(), "florian", "pwd");
if (user != null)
{
Console.WriteLine(user.Firstname);
Console.WriteLine(user.Lastname);
}
else
{
Console.WriteLine("Not found");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
Console.Read();
}
private static void AddDapper(this IServiceCollection services, string connectionString)
{
services.AddTransient(typeof(IRepository <>), typeof(DapperRepository <>));
services.AddScoped <IUnitOfWork, DapperUnitOfWork>();
services.AddTransient <IQueryService>(provider => {
var dapperQueryService = new DapperQueryService(provider.GetRequiredService <IDbConnectionFactory>(), connectionString);
return(dapperQueryService);
});
services.AddSingleton <IDbConnectionFactory, DapperDbConnectionFactory <SqlConnection> >();
services.AddTransient <IDbConnection>(provider => { return(new SqlConnection(connectionString)); });
DapperConfiguration.Initialize();
}
public static void Register(HttpConfiguration config)
{
// Web-API-Konfiguration und -Dienste
//TODO Frage?????
DapperConfiguration.Initialize();
// Web-API-Routen
config.MapHttpAttributeRoutes();
//routeTemplate: "api/{controller}/{id}",
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{action}/{id}",
defaults: new { id = RouteParameter.Optional }
);
config.Formatters.JsonFormatter.SupportedMediaTypes.Add(
new MediaTypeHeaderValue("text/html"));
}
public static void Register(HttpConfiguration config)
{
// Web API configuration and services
DapperConfiguration.Initialize();
// Web API routes
config.MapHttpAttributeRoutes();
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
config.Formatters.JsonFormatter.SupportedMediaTypes.Add(
new System.Net.Http.Headers.MediaTypeHeaderValue("text/html"));
}