public static void Init(TestContext context)
{
DropCreateDatabase();
Config =
MsSqlConfiguration.MsSql2012.ConnectionString(
ConfigurationManager.ConnectionStrings["RepoTest"].ConnectionString).ShowSql();
}
private static MsSqlConfiguration GetMSMsSqlConfigurationByEnvironment(DBEnvironment _environment)
{
var connectionString = DatabaseUtil.GetConnectionStringByEnvironment(_environment);
MsSqlConfiguration config = null;
var version = (DBMSSQLServerVersion)_environment.DBMSVersion;
switch (version)
{
case DBMSSQLServerVersion.Versao2005:
config = MsSqlConfiguration.MsSql2005.ConnectionString(connectionString);
break;
case DBMSSQLServerVersion.Versao2008:
config = MsSqlConfiguration.MsSql2008.ConnectionString(connectionString);
break;
case DBMSSQLServerVersion.Versao2012:
config = MsSqlConfiguration.MsSql2012.ConnectionString(connectionString);
break;
default:
config = MsSqlConfiguration.MsSql2008.ConnectionString(connectionString);
break;
}
return(config);
}
public void Run()
{
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(x => x.FromConnectionStringWithKey("MiniTrello.Remote"));
container.Register(c => c.Resolve <ISessionFactory>().OpenSession()).As
<ISession>()
.InstancePerLifetimeScope()
.OnActivating(c =>
{
if (!c.Instance.Transaction.IsActive)
{
c.Instance.BeginTransaction();
}
}
)
.OnRelease(c =>
{
if (c.Transaction.IsActive)
{
c.Transaction.Commit();
}
c.Dispose();
});
container.Register(c =>
new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration).Build())
.SingleInstance()
.As <ISessionFactory>();
}
private static ISessionFactory GetSQLServerSessionFactory(DBEnvironment _environment)
{
ISessionFactory factory = null;
String connectionString = DatabaseUtil.GetConnectionStringByEnvironment(_environment);
Assembly mapping = GetAssemblyWithMapping();
MsSqlConfiguration configurer = GetMSMsSqlConfigurationByEnvironment(_environment);
FluentConfiguration config = Fluently.Configure()
.Database(configurer)
.CurrentSessionContext("context")
.Cache(
c => c.UseQueryCache().UseSecondLevelCache()
)
.Mappings(m => m.FluentMappings.AddFromAssembly(mapping)
);
Assembly secondMapping = GetSecondAssemblyWithMapping();
Assembly thirdMapping = GetThirdAssemblyWithMapping();
factory = config.BuildSessionFactory();
return(factory);
}
public MsSqlMessageConsumer(
MsSqlConfiguration msSqlConfiguration,
string topic, IMsSqlConnectionProvider connectionProvider)
{
_topic = topic ?? throw new ArgumentNullException(nameof(topic));
_sqlQ = new MsSqlMessageQueue <Message>(msSqlConfiguration, connectionProvider);
}
static void Main(string[] args)
{
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(x => x.FromConnectionStringWithKey("CrudGesitonContenido.Local"));
DomainDrivenDatabaseDeployer.DatabaseDeployer dd = null;
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration)
.Build(cfg => { dd = new DomainDrivenDatabaseDeployer.DatabaseDeployer(cfg); });
dd.Drop();
Console.WriteLine("Database dropped.");
Thread.Sleep(1000);
dd.Create();
Console.WriteLine("Database created.");
ISession session = sessionFactory.OpenSession();
using (ITransaction tx = session.BeginTransaction())
{
dd.Seed(new List <IDataSeeder>
{
new DepartamentoSeeder(session)
});
tx.Commit();
}
session.Close();
sessionFactory.Close();
Console.WriteLine("Seed data added.");
Thread.Sleep(2000);
}
static void Main()
{
Log.Logger = new LoggerConfiguration()
.MinimumLevel.Debug()
.Enrich.FromLogContext()
.WriteTo.Console()
.CreateLogger();
var serviceCollection = new ServiceCollection();
serviceCollection.AddSingleton <ILoggerFactory>(new SerilogLoggerFactory());
var messagingConfiguration = new MsSqlConfiguration(@"Database=BrighterSqlQueue;Server=.\sqlexpress;Integrated Security=SSPI;", queueStoreTable: "QueueData");
serviceCollection.AddBrighter()
.UseInMemoryOutbox()
.UseExternalBus(new MsSqlProducerRegistryFactory(
messagingConfiguration,
new Publication[] { new Publication() }
)
.Create())
.AutoFromAssemblies();
var serviceProvider = serviceCollection.BuildServiceProvider();
var commandProcessor = serviceProvider.GetService <IAmACommandProcessor>();
commandProcessor.Post(new GreetingEvent("Ian"));
}
public static void Init(TestContext context)
{
DropCreateDatabase();
Configuration =
MsSqlConfiguration.MsSql2012.ConnectionString(
ConfigurationManager.ConnectionStrings[DbConfig].ConnectionString);
}
private ISessionFactory getSessionFactory()
{
if (_sessionFactory == null)
{
IAutomappingConfiguration cfg = new MyAutoMappingCfg();
MsSqlConfiguration msconfg
= MsSqlConfiguration
.MsSql2008
.ConnectionString(s => s.FromConnectionStringWithKey("xhg"))
.ShowSql();
_sessionFactory = Fluently.Configure()
.Database(msconfg)
.Mappings(
// m => m.AutoMappings.Add(AutoMap.AssemblyOf<Model.Product>())
m => m.FluentMappings.AddFromAssemblyOf <DAL.Mapping.CategoryMap>())
.ExposeConfiguration(BuildSchema)
.BuildSessionFactory();
}
return(_sessionFactory);
}
static void Main(string[] args)
{
string connectionString = ConnectionStrings.Get();
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(x => x.Is(connectionString));
DomainDrivenDatabaseDeployer.DatabaseDeployer dd = null;
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration)
.Build(cfg => { dd = new DomainDrivenDatabaseDeployer.DatabaseDeployer(cfg); });
dd.Drop();
Console.WriteLine("Database dropped.");
Thread.Sleep(1000);
dd.Create();
Console.WriteLine("Database created.");
ISession session = sessionFactory.OpenSession();
using (ITransaction tx = session.BeginTransaction())
{
dd.Seed(new List <IDataSeeder>
{
new AccountSeeder(session),
});
tx.Commit();
}
session.Close();
sessionFactory.Close();
Console.WriteLine("Seed data added.");
Thread.Sleep(2000);
}
protected void TestSqlSettingsClick(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(textboxSqlDatabase.Text) || String.IsNullOrEmpty(textboxSqlServerPath.Text) ||
String.IsNullOrEmpty(textboxSqlUsername.Text) || String.IsNullOrEmpty(textboxSqlPassword.Text))
{
labelMessage.Text = "You must complete all the SQL configuration fields to test your SQL connectivity";
return;
}
AbstractSqlConfiguration sqlConfig = new MsSqlConfiguration();
sqlConfig.Database = textboxSqlDatabase.Text;
sqlConfig.Hostname = textboxSqlServerPath.Text;
sqlConfig.Username = textboxSqlUsername.Text;
sqlConfig.Password = textboxSqlPassword.Text;
ConnectionTester dao = new ConnectionTester(sqlConfig.buildConnectionString());
dto.BoolTO result = dao.canWrite();
if (result.trueOrFalse)
{
labelMessage.Text = "You were able to write to your database with these SQL settings. Good job!";
}
else if (result.fault != null)
{
labelMessage.Text = "<p>MDWS failed to write to your database with those SQL settings. Maybe the " +
"following error will give you a clue why:</p>" + result.fault.message;
}
else
{
labelMessage.Text = "MDWS couldn't successfully connect to your database with those parameters " +
"but no error was reported. You got yourself a real pickle there.";
}
}
/// <summary>
/// The Abstract Base class
/// </summary>
/// <param name="configuration">Ms Sql Configuration.</param>
/// <param name="cacheTokens">Cache Access Tokens until they have less than 5 minutes of life left.</param>
protected MsSqlAzureConnectionProviderBase(MsSqlConfiguration configuration, bool cacheTokens = true)
{
_cacheTokens = cacheTokens;
_connectionString = configuration.ConnectionString;
_authenticationTokenScopes = new string[1] {
_azureScope
};
}
private ISessionFactory CreateSessionFactory()
{
MsSqlConfiguration msSqlConfiguration = MsSqlConfiguration.MsSql2008.ConnectionString(_connectionString).AdoNetBatchSize(1000);
return(Fluently.Configure()
.Database(msSqlConfiguration)
.Mappings(Mappings())
.BuildSessionFactory());
}
public static ISessionFactory CreateSessionFactory()
{
string connectionString = ConnectionStrings.Get();
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(x => x.Is(connectionString));
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration).Build();
return(sessionFactory);
}
protected IDictionary <string, string> GetProperties()
{
MsSqlConfiguration config = MsSqlConfiguration.MsSql2005;
config.ConnectionString.FromConnectionStringWithKey("MYDBKEY");
config.ShowSql();
config.UseOuterJoin();
return(config.ToProperties());
}
/// <summary>
/// Initializes a new instance of the <see cref="MsSqlMessageQueue{T}" /> class.
/// </summary>
/// <param name="configuration"></param>
public MsSqlMessageQueue(MsSqlConfiguration configuration, IMsSqlConnectionProvider connectionProvider)
{
_configuration = configuration ?? throw new ArgumentNullException(nameof(configuration));
_connectionProvider = connectionProvider;
if (s_logger.IsEnabled(LogLevel.Debug))
{
s_logger.LogDebug("MsSqlMessageQueue({ConnectionString}, {QueueStoreTable})", _configuration.ConnectionString, _configuration.QueueStoreTable);
}
ContinueOnCapturedContext = false;
}
/// <summary>
/// Initialise a new instance of Ms Sql Connection provider using Default Azure Credentials to acquire Access Tokens.
/// </summary>
/// <param name="configuration">Ms Sql Configuration</param>
/// <param name="credentialSources">List of Token Providers to use when trying to obtain a token.</param>
public ServiceBusChainedClientProvider(MsSqlConfiguration configuration,
params TokenCredential[] credentialSources) : base(configuration)
{
if (credentialSources == null || credentialSources.Length < 1)
{
throw new ArgumentNullException(nameof(credentialSources),
"Credential Sources is null or empty, ensure this is set in the constructor.");
}
_credential = new ChainedTokenCredential(credentialSources);
}
/// <summary>
/// Use MsSql for the Outbox
/// </summary>
/// <param name="brighterBuilder">Allows extension method syntax</param>
/// <param name="configuration">The connection for the Db and name of the Outbox table</param>
/// <param name="connectionProvider">What is the type for the class that lets us obtain connections for the Sqlite database</param>
/// <param name="serviceLifetime">What is the lifetime of the services that we add</param>
/// <returns>Allows fluent syntax</returns>
/// -- Registers the following
/// -- MsSqlConfigutation: connection string and outbox name
/// -- IMsSqlConnectionProvider: lets us get a connection for the outbox that matches the entity store
/// -- IAmAnOutbox<Message>: an outbox to store messages we want to send
/// -- IAmAnOutboxAsync<Message>: an outbox to store messages we want to send
/// -- IAmAnOutboxViewer<Message>: Lets us read the entries in the outbox
/// -- IAmAnOutboxViewerAsync<Message>: Lets us read the entries in the outbox
public static IBrighterBuilder UseMsSqlOutbox(
this IBrighterBuilder brighterBuilder, MsSqlConfiguration configuration, Type connectionProvider, ServiceLifetime serviceLifetime = ServiceLifetime.Singleton)
{
brighterBuilder.Services.AddSingleton <MsSqlConfiguration>(configuration);
brighterBuilder.Services.Add(new ServiceDescriptor(typeof(IMsSqlConnectionProvider), connectionProvider, serviceLifetime));
brighterBuilder.Services.Add(new ServiceDescriptor(typeof(IAmAnOutboxSync <Message>), BuildMsSqlOutbox, serviceLifetime));
brighterBuilder.Services.Add(new ServiceDescriptor(typeof(IAmAnOutboxAsync <Message>), BuildMsSqlOutbox, serviceLifetime));
return(brighterBuilder);
}
private readonly IEnumerable <Publication> _publications; //-- placeholder for future use
public MsSqlProducerRegistryFactory(
MsSqlConfiguration msSqlConfiguration,
IEnumerable <Publication> publications)
{
_msSqlConfiguration =
msSqlConfiguration ?? throw new ArgumentNullException(nameof(msSqlConfiguration));
if (string.IsNullOrEmpty(msSqlConfiguration.QueueStoreTable))
{
throw new ArgumentNullException(nameof(msSqlConfiguration.QueueStoreTable));
}
_publications = publications;
}
// Returns our database configuration
private static MsSqlConfiguration CreateMSSqlDbConfig2()
{
MsSqlConfiguration MsSqlConfiguration = MsSqlConfiguration.MsSql2008.ConnectionString(c => c.FromConnectionStringWithKey("mssqlserverConn2"))
#region Debug
#if debug
.ShowSql()
#endif
;
#endregion
return(MsSqlConfiguration);
}
public static ISessionFactory CreateSessionFactory()
{
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(
x =>
x.FromConnectionStringWithKey(
"MiniDropbox.Remote"));
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration)
.Build();
return(sessionFactory);
}
private static IPersistenceConfigurer MsSqlConfigureDatabase2008(NHConfigurationSection nhConfiguration)
{
MsSqlConfiguration cfg = MsSqlConfiguration.MsSql2008
.ConnectionString(c => c.FromConnectionStringWithKey(nhConfiguration.ConnectionStringName))
.UseOuterJoin()
.DefaultSchema(nhConfiguration.DatabaseSchema);
#if DEBUG
cfg.ShowSql();
#endif
return(cfg);
}
public TestBase()
{
MsSqlConfiguration persistenceConfigurer = MsSqlConfiguration
.MsSql2008
.ConnectionString("Data Source=localhost;Initial Catalog=TestDb;Integrated Security=True;Enlist=false")
.Raw("connection.release_mode", "on_close");
sessionFactory = Fluently
.Configure()
.Database(persistenceConfigurer)
.Mappings(m => m.FluentMappings.AddFromAssembly(typeof(User).Assembly))
.BuildSessionFactory();
}
public static ISessionFactory CreateSessionFactory()
{
//MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
// ConnectionString(@"Data Source=WMXAP250360-BZC\SQLEXPRESS;Initial Catalog=CrudGestion;User ID=sa;Password=Hello/123");
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(@"Server=3f4d7894-b3bd-4bfa-a563-a772003bc6ec.sqlserver.sequelizer.com;Database=db3f4d7894b3bd4bfaa563a772003bc6ec;User ID=wdjbitzpwlgrugka;Password=cf8TViMUhgc5uHVwLLxiKsjFEVJfTATRsCyynT4SCK4mRaptPYdjYqyR4Ao8GGaN;");
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration)
.Build();
return(sessionFactory);
}
private Publication _publication; // -- placeholder for future use
public MsSqlMessageProducer(
MsSqlConfiguration msSqlConfiguration,
IMsSqlConnectionProvider connectionProvider,
Publication publication = null)
{
_sqlQ = new MsSqlMessageQueue <Message>(msSqlConfiguration, connectionProvider);
_publication = publication ?? new Publication()
{
MakeChannels = OnMissingChannel.Create
};
MaxOutStandingMessages = _publication.MaxOutStandingMessages;
MaxOutStandingCheckIntervalMilliSeconds = _publication.MaxOutStandingCheckIntervalMilliSeconds;
}
/// <summary>
/// Конфигуратор хранилища.
/// </summary>
/// <returns></returns>
protected virtual IPersistenceConfigurer GetPersistenceConfigurer()
{
var builder = new SqlConnectionStringBuilder(this.ConnectionString);
builder.ConnectTimeout = this.ConnectionTimeout;
MsSqlConfiguration config = MsSqlConfiguration.MsSql2005.ConnectionString(builder.ConnectionString);
if (!String.IsNullOrWhiteSpace(this.Schema))
{
config.DefaultSchema(this.Schema);
}
return(config);
}
ISessionFactory CreateSessionFactory(string connectionString)
{
MsSqlConfiguration config = MsSqlConfiguration.MsSql2012
.ConnectionString(connectionString)
.ShowSql()
.FormatSql();
Console.SetOut(outputCache);
Assembly currentAssembly = Assembly.GetExecutingAssembly();
return(Fluently
.Configure()
.Database(config)
.Mappings(mapping => mapping.FluentMappings.AddFromAssembly(currentAssembly))
.BuildSessionFactory());
}
public static void Configurar()
{
string connectionString = "Data Source=SERVIDOR;Initial Catalog=BancoDeDados;User ID=Usuario;Password=Senha";
MsSqlConfiguration configuracao = MsSqlConfiguration.MsSql2012
.ConnectionString(connectionString);
FluentConfiguration fluentConfig = Fluently.Configure()
.Database(configuracao)
.Mappings(mappingConfiguration =>
{
mappingConfiguration.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly());
}).ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(true, true));
sessionFactory = fluentConfig.BuildSessionFactory();
}
public static void Configurar()
{
string connectionString = @"Data Source=.\DEV;Initial Catalog=Simbra;Integrated Security=True";
MsSqlConfiguration configuracao = MsSqlConfiguration.MsSql2012.ConnectionString(connectionString);
FluentConfiguration fluentConfiguracao = Fluently
.Configure()
.Database(configuracao)
.Mappings(c =>
{
c.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly());
}).ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(true, true));
sessionFactory = fluentConfiguracao.BuildSessionFactory();
}
private static void Main(string[] args)
{
try
{
string connectionString = ConnectionStrings.Get();
MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().
ConnectionString(x => x.Is(connectionString));
DomainDrivenDatabaseDeployer.DatabaseDeployer dd = null;
ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration)
.Build(cfg => { dd = new DomainDrivenDatabaseDeployer.DatabaseDeployer(cfg); });
dd.Drop();
Console.WriteLine("Database dropped.");
Thread.Sleep(1000);
dd.Create();
Console.WriteLine("Database created.");
ISession session = sessionFactory.OpenSession();
using (ITransaction tx = session.BeginTransaction())
{
dd.Seed(new List <IDataSeeder>
{
new UserSeeder(session),
new ProjectEntitySeeder(session),
new UserTypeEntitySeeder(session),
new UserHistoryEntitySeeder(session)
});
tx.Commit();
}
session.Close();
sessionFactory.Close();
Console.WriteLine("Seed data added.");
Thread.Sleep(2000);
}
catch (Exception ex)
{
String innerMessage = (ex.InnerException != null)
? ex.InnerException.Message
: "";
Console.WriteLine(ex.Message);
Console.WriteLine(innerMessage);
string n = Console.ReadLine();
}
}
