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(); } }