public static void RegisterServices(IKernel kernel)
{
kernel.Bind <IMapper>().ToMethod(k =>
{
Mapper.Initialize(cfg => {
cfg.CreateMap <Bug, BugEntity>(MemberList.Source);
cfg.CreateMap <BugEntity, Bug>(MemberList.Source);
});
return(Mapper.Instance);
}).InSingletonScope();
kernel.Bind <IBugRepository>().To <BugRepository>().InSingletonScope();
kernel.Bind <IDbContextFactory>().ToMethod(k =>
{
var connectionOptions = new SqlConnectionOptions
{
DataSource = WebConfigurationManager.AppSettings["SqlConnection.DataSource"],
InitialCatalog = WebConfigurationManager.AppSettings["SqlConnection.InitialCatalog"],
UseWindowsAuthentication = true
};
return(new DbContextFactory(connectionOptions));
}).InSingletonScope();
}
/// <inheritdoc/>
public override void UseMicrosoft(IConfiguration configuration)
{
var connectionString = configuration
.GetConnectionString(this.ConnectionString);
var connection = new SqlConnectionOptions(connectionString)
{
ValidateSchema = true
};
this.Container.RegisterAbbotwareContext <TContext>(connection, new SqlOptionsAdapter <TContext>());
}
/// <summary>
/// Use the Microsoft.Extensions.Configuration as a source for connection string
/// </summary>
/// <param name="configuration">configuration</param>
public virtual void UseMicrosoft(IConfiguration configuration)
{
Arguments.NotNull(configuration, nameof(configuration));
var connectionString = configuration
.GetConnectionString(this.ConnectionString);
var connection = new SqlConnectionOptions(connectionString)
{
ValidateSchema = true
};
this.Container.RegisterDbContext <TContext>(connection, new SqlOptionsAdapter <TContext>());
}
public void StartTestVoid()
{
var sqlConnection = new SqlConnectionOptions {
ConnectionString = @"Server=(localdb)\mssqllocaldb;Database=EFProviders.InMemory;Trusted_Connection=True;ConnectRetryCount=3"
};
_repository = new RepositoryStoreFactory <TestDocument>("ECommerce.Data.EntityFramework",
new ConnectionOptions
{
Provider = "ECommerce.Data.EntityFramework.InMemory",
ConnectionString = JsonConvert.SerializeObject(sqlConnection)
},
_loggerFactory, new MyDiagnosticSource());
}
public void StartTestVoid()
{
var sqlConnection = new SqlConnectionOptions {
ConnectionString = $"Data Source={new FileInfo("data\\data.db").FullName}"
};
_repository = new RepositoryStoreFactory <TestDocument>("ECommerce.Data.EntityFramework",
new ConnectionOptions
{
Provider = "ECommerce.Data.EntityFramework.SqlLite",
ConnectionString = JsonConvert.SerializeObject(sqlConnection)
},
_loggerFactory, new MyDiagnosticSource());
}
public IActionResult Index(MigrateModel model)
{
SqlConnectionOptions con = new SqlConnectionOptions();
con.DataSource = model.DataSource;
con.InitialCatalog = model.InitialCatalog;
con.UserID = model.UserID;
con.Password = model.Password;
if (String.IsNullOrWhiteSpace(con.InitialCatalog))
{
con.InitialCatalog = "DESAFIO";
}
try
{
if (RepositoryBase.IsValidServer(con))
{
if (!RepositoryBase.IsValidOptions(con))
{
RepositoryBase.CriarBanco(con);
}
this._configuration.Value.InitialCatalog = con.InitialCatalog;
this._configuration.Value.DataSource = con.DataSource;
this._configuration.Value.UserID = con.UserID;
this._configuration.Value.Password = con.Password;
return(RedirectToAction(nameof(LoginController.Index), "Login"));
}
else
{
model.Mensagem = "Configurações do banco incorretas";
}
}
catch (Exception ex)
{
model.Mensagem = "Erro: " + ex.Message;
}
return(View(model));
}
public static string Create(SqlConnectionOptions sqlConnectionOptions)
{
return(sqlConnectionOptions.UseWindowsAuthentication
? CreateWithWindowsAuthentication(sqlConnectionOptions)
: CreateWithUserCredentials(sqlConnectionOptions));
}
private static string CreateWithWindowsAuthentication(SqlConnectionOptions sqlConnectionOptions)
{
return($"Persist Security Info=False;Data Source={sqlConnectionOptions.DataSource};Initial Catalog={sqlConnectionOptions.InitialCatalog};Integrated Security=True");
}
private static string CreateWithUserCredentials(SqlConnectionOptions sqlConnectionOptions)
{
return($"Persist Security Info=False;Data Source={sqlConnectionOptions.DataSource};Initial Catalog={sqlConnectionOptions.InitialCatalog};User ID={sqlConnectionOptions.User};Password={sqlConnectionOptions.Password};Application Name=BugHub");
}
public CadastroAmigoController(
IOptions <SqlConnectionOptions> configuration)
{
_configuration = configuration.Value;
}
public LoginStore(IOptions <SqlConnectionOptions> configuration)
{
_connectionOpt = configuration.Value;
}
public DbContextFactory(SqlConnectionOptions sqlConnectionOptions)
{
_sqlConnectionOptions = sqlConnectionOptions;
}
public HomeController(
IOptions <SqlConnectionOptions> configuration)
{
_configuration = configuration.Value;
}
