本文整理汇总了C#中Configuration.DataBaseIntegration方法的典型用法代码示例。如果您正苦于以下问题:C# Configuration.DataBaseIntegration方法的具体用法?C# Configuration.DataBaseIntegration怎么用?C# Configuration.DataBaseIntegration使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Configuration
的用法示例。
在下文中一共展示了Configuration.DataBaseIntegration方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetAll
public IList<INotification> GetAll()
{
// webbikäyttöön
// App_Start.NHibernateProfilerBootstrapper.PreStart();
// konsolissa
// NHibernateProfiler.Initialize();
IList<INotification> notifications;
var cfg = new Configuration();
cfg.DataBaseIntegration(x =>
{
x.ConnectionString = "Server=localhost;Database=NHibernateDemo;Integrated Security=SSPI;";
x.Driver<SqlClientDriver>();
x.Dialect<MsSql2008Dialect>();
//x.LogFormattedSql = true;
//x.LogSqlInConsole = true;
});
cfg.SessionFactory().GenerateStatistics();
cfg.AddAssembly(Assembly.Load("Domain"));
var sessionFactory = cfg.BuildSessionFactory();
var session = sessionFactory.OpenSession();
var notificationsQueryable =
from customer in session.Query<INotification>()
//where customer.FirstName.Contains("e")
orderby customer.FirstName
select customer;
notifications = notificationsQueryable.ToList();
return notifications;
}
示例2: CriarSchema
public void CriarSchema()
{
// Apenas no Init da Aplicação
var config = new Configuration();
config.DataBaseIntegration(c =>
{
c.Dialect<MsSql2012Dialect>();
c.ConnectionStringName = "ExemploNH";
c.LogFormattedSql = true;
c.LogSqlInConsole = true;
c.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote;
});
var modelMapper = new ModelMapper();
modelMapper.AddMappings(typeof (ProdutoMap).Assembly.GetExportedTypes());
config.AddDeserializedMapping(modelMapper.CompileMappingForAllExplicitlyAddedEntities(), "Domain");
ISessionFactory sessionFactory = config.BuildSessionFactory();
// NOTE: Estudar framework FluentMigration
var schemaExport = new SchemaExport(config);
schemaExport.Create(true, true);
}
示例3: AsyncMain
static async Task AsyncMain()
{
Console.Title = "Samples.SqlNHibernate.Receiver";
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
#region NHibernate
hibernateConfig.SetProperty("default_schema", "receiver");
#endregion
ModelMapper mapper = new ModelMapper();
mapper.AddMapping<OrderMap>();
hibernateConfig.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities());
new SchemaExport(hibernateConfig).Execute(false, true, false);
#region ReceiverConfiguration
EndpointConfiguration endpointConfiguration = new EndpointConfiguration("Samples.SqlNHibernate.Receiver");
endpointConfiguration.SendFailedMessagesTo("error");
endpointConfiguration.AuditProcessedMessagesTo("audit");
endpointConfiguration.EnableInstallers();
endpointConfiguration.UseTransport<SqlServerTransport>()
.DefaultSchema("receiver")
.UseSpecificSchema(e =>
{
if (e == "error" || e == "audit")
{
return "dbo";
}
if (e == "Samples.SqlNHibernate.Sender")
{
return "sender";
}
return null;
});
endpointConfiguration.UsePersistence<NHibernatePersistence>()
.UseConfiguration(hibernateConfig);
#endregion
IEndpointInstance endpoint = await Endpoint.Start(endpointConfiguration);
try
{
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
finally
{
await endpoint.Stop();
}
}
示例4: AsyncMain
static async Task AsyncMain()
{
Console.Title = "Samples.SQLNHibernateOutboxEF.Receiver";
using (ReceiverDataContext ctx = new ReceiverDataContext())
{
ctx.Database.Initialize(true);
}
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
hibernateConfig.SetProperty("default_schema", "receiver");
EndpointConfiguration endpointConfiguration = new EndpointConfiguration("Samples.SQLNHibernateOutboxEF.Receiver");
endpointConfiguration.UseSerialization<JsonSerializer>();
#region ReceiverConfiguration
endpointConfiguration
.UseTransport<SqlServerTransport>()
.DefaultSchema("receiver")
.UseSpecificSchema(queueName =>
{
if (queueName.Equals("error", StringComparison.OrdinalIgnoreCase) || queueName.Equals("audit", StringComparison.OrdinalIgnoreCase))
{
return "dbo";
}
if (queueName.Equals("Samples.SQLNHibernateOutboxEF.Sender", StringComparison.OrdinalIgnoreCase))
{
return "sender";
}
return null;
});
endpointConfiguration
.UsePersistence<NHibernatePersistence>();
endpointConfiguration.EnableOutbox();
#endregion
IEndpointInstance endpoint = await Endpoint.Start(endpointConfiguration);
try
{
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
finally
{
await endpoint.Stop();
}
}
示例5: Main
static void Main()
{
Console.Title = "Samples.SQLNHibernateOutboxEF.Sender";
const string letters = "ABCDEFGHIJKLMNOPQRSTUVXYZ";
var random = new Random();
var hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
hibernateConfig.SetProperty("default_schema", "sender");
var busConfiguration = new BusConfiguration();
busConfiguration.UseSerialization<JsonSerializer>();
busConfiguration.EndpointName("Samples.SQLNHibernateOutboxEF.Sender");
#region SenderConfiguration
var transport = busConfiguration.UseTransport<SqlServerTransport>();
transport.UseSpecificConnectionInformation(
EndpointConnectionInfo.For("Samples.SQLNHibernateOutboxEF.Receiver").UseSchema("receiver"));
transport.DefaultSchema("sender");
busConfiguration.UsePersistence<NHibernatePersistence>();
busConfiguration.EnableOutbox();
#endregion
using (var bus = Bus.Create(busConfiguration).Start())
{
Console.WriteLine("Press enter to send a message");
Console.WriteLine("Press any key to exit");
while (true)
{
var key = Console.ReadKey();
Console.WriteLine();
if (key.Key != ConsoleKey.Enter)
{
return;
}
var orderId = new string(Enumerable.Range(0, 4).Select(x => letters[random.Next(letters.Length)]).ToArray());
var orderSubmitted = new OrderSubmitted
{
OrderId = orderId,
Value = random.Next(100)
};
bus.Publish(orderSubmitted);
}
}
}
示例6: AsyncMain
static async Task AsyncMain()
{
BusConfiguration busConfiguration = new BusConfiguration();
busConfiguration.SendFailedMessagesTo("error");
busConfiguration.EnableInstallers();
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
hibernateConfig.SetProperty("default_schema", "sender");
#region SenderConfiguration
busConfiguration.UseTransport<SqlServerTransport>()
.DefaultSchema("sender")
.UseSpecificSchema(e => "receiver");
busConfiguration.UsePersistence<NHibernatePersistence>()
.UseConfiguration(hibernateConfig);
#endregion
IEndpointInstance endpoint = await Endpoint.Start(busConfiguration);
try
{
Console.WriteLine("Press enter to send a message");
Console.WriteLine("Press any key to exit");
while (true)
{
ConsoleKeyInfo key = Console.ReadKey();
Console.WriteLine();
if (key.Key != ConsoleKey.Enter)
{
return;
}
string orderId = new string(Enumerable.Range(0, 4).Select(x => letters[random.Next(letters.Length)]).ToArray());
await endpoint.Publish(new OrderSubmitted
{
OrderId = orderId,
Value = random.Next(100)
});
}
}
finally
{
await endpoint.Stop();
}
}
示例7: Main
static void Main()
{
Console.Title = "Samples.SqlNHibernate.Receiver";
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
#region NHibernate
hibernateConfig.SetProperty("default_schema", "receiver");
#endregion
ModelMapper mapper = new ModelMapper();
mapper.AddMapping<OrderMap>();
hibernateConfig.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities());
new SchemaExport(hibernateConfig).Execute(false, true, false);
BusConfiguration busConfiguration = new BusConfiguration();
busConfiguration.EndpointName("Samples.SqlNHibernate.Receiver");
busConfiguration.EnableInstallers();
#region ReceiverConfiguration
busConfiguration.UseTransport<SqlServerTransport>()
.DefaultSchema("receiver")
.UseSpecificConnectionInformation(endpoint =>
{
if (endpoint == "error" || endpoint == "audit")
{
return ConnectionInfo.Create().UseSchema("dbo");
}
if (endpoint == "Samples.SqlNHibernate.Sender")
{
return ConnectionInfo.Create().UseSchema("sender");
}
return null;
});
busConfiguration.UsePersistence<NHibernatePersistence>()
.UseConfiguration(hibernateConfig)
.RegisterManagedSessionInTheContainer();
#endregion
using (Bus.Create(busConfiguration).Start())
{
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
}
示例8: ExportSchema
public void ExportSchema()
{
// Inicio do Setup do NH
var config = new Configuration();
config.DataBaseIntegration(
db =>
{
db.Dialect<MsSql2008Dialect>();
db.ConnectionStringName = "DefaultNH";
db.SchemaAction = SchemaAutoAction.Recreate;
});
ModelMapper modelMapper = new ModelMapper();
modelMapper.AddMapping<ProdutoNHMap>();
modelMapper.AddMapping<DepartamentoNHMap>();
config.AddDeserializedMapping(modelMapper.CompileMappingForAllExplicitlyAddedEntities(), "Domain");
ISessionFactory sessionFactory = config.BuildSessionFactory();
// Fim do Setup do NH - Isso deve ficar no start da app (Global.asax por exemplo)
using (var session = sessionFactory.OpenSession())
{
// Criteria API
// HQL
// Linq
var produtosAcima1000 = session.QueryOver<Produto>().List();
foreach (var produto in produtosAcima1000)
{
Console.WriteLine(produto);
}
}
using (var session = sessionFactory.OpenSession())
{
var produto = new Produto();
produto.Nome = "Teste #1";
produto.Preco = 90;
produto.Quantidade = 123;
produto.Ativo = true;
session.Save(produto);
session.Flush();
}
}
示例9: FactoryProvider
static FactoryProvider()
{
var modelInspector = new MySimpleModelInspector();
Assert.IsNotNull(new Entity());
var mapper = new ModelMapper(modelInspector);
mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes());
mapper.BeforeMapClass += (mi, type, map) =>
map.Id(idmap => idmap.Generator(Generators.HighLow,
gmap => gmap.Params(new
{
table = "NextHighVaues",
column = "NextHigh",
max_lo = 100,
where = String.Format("EntityName = '{0}'", type.Name.ToLowerInvariant())
})));
mapper.BeforeMapClass += (mi, t, map) => map.Table(t.Name.ToLowerInvariant());
mapper.BeforeMapJoinedSubclass += (mi, t, map) => map.Table(t.Name.ToLowerInvariant());
mapper.BeforeMapUnionSubclass += (mi, t, map) => map.Table(t.Name.ToLowerInvariant());
mapper.BeforeMapProperty += (mi, propertyPath, map) =>
{
if (typeof(decimal).Equals(propertyPath.LocalMember.GetPropertyOrFieldType()))
{
map.Type(NHibernateUtil.Currency);
}
};
mapper.BeforeMapBag += (mi, propPath, map) =>
{
map.Cascade(Cascade.All.Include(Cascade.DeleteOrphans));
map.BatchSize(10);
};
mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes());
var domainMapping = mapper.CompileMappingForEachExplicitlyAddedEntity();
domainMapping.WriteAllXmlMapping();
var configuration = new Configuration();
configuration.DataBaseIntegration(c =>
{
c.Dialect<MsSql2008Dialect>();
c.ConnectionString = @"Data Source=localhost\SQLEXPRESS;Initial Catalog=IntroNH;Integrated Security=True;Pooling=False";
c.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote;
c.SchemaAction = SchemaAutoAction.Create;
});
foreach(var mapping in domainMapping)
{
configuration.AddMapping(mapping);
}
configuration.AddAuxiliaryDatabaseObject(CreateHighLowScript(modelInspector, Assembly.GetExecutingAssembly().GetExportedTypes()));
Factory=configuration.BuildSessionFactory();
}
示例10: Main
static void Main()
{
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
#region NHibernate
hibernateConfig.SetProperty("default_schema", "receiver");
#endregion
ModelMapper mapper = new ModelMapper();
mapper.AddMapping<OrderMap>();
hibernateConfig.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities());
new SchemaExport(hibernateConfig).Execute(false, true, false);
#region ReceiverConfiguration
BusConfiguration busConfiguration = new BusConfiguration();
busConfiguration.UseTransport<SqlServerTransport>()
.DefaultSchema("receiver")
.UseSpecificConnectionInformation(endpoint =>
{
if (endpoint == "error")
{
return ConnectionInfo.Create().UseSchema("dbo");
}
if (endpoint == "audit")
{
return ConnectionInfo.Create().UseSchema("dbo");
}
string schema = endpoint.Split(new[] { '.' }, StringSplitOptions.RemoveEmptyEntries)[0].ToLowerInvariant();
return ConnectionInfo.Create().UseSchema(schema);
});
busConfiguration.UsePersistence<NHibernatePersistence>()
.UseConfiguration(hibernateConfig)
.RegisterManagedSessionInTheContainer();
#endregion
using (Bus.Create(busConfiguration).Start())
{
Console.WriteLine("Press <enter> to exit");
Console.ReadLine();
}
}
示例11: CreateConfiguration
public static Configuration CreateConfiguration(string connectionStringName = "Restbucks")
{
var configuration = new Configuration();
configuration.DataBaseIntegration(db =>
{
db.Dialect<MsSql2008Dialect>();
db.ConnectionStringName = connectionStringName;
db.LogFormatedSql = true;
db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote;
});
configuration.CurrentSessionContext<CallSessionContext>();
configuration.CollectionTypeFactory<Net4CollectionTypeFactory>();
configuration.AddDeserializedMapping(Mapper.Generate(), "Restbucks");
return configuration;
}
示例12: CreateSession
protected virtual ISession CreateSession(bool withLogging)
{
IDbConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString);
con.Open();
var cfg = new Configuration();
cfg.Configure(Path.Combine(AppDomain.CurrentDomain.BaseDirectory,"hibernate.cfg.xml"));
if (withLogging)
{
cfg.DataBaseIntegration(x =>
{
x.LogSqlInConsole = true;
x.LogFormattedSql = true;
});
}
var factory = cfg.BuildSessionFactory();
return factory.OpenSession(con);
}
示例13: Main
static void Main()
{
Console.Title = "Samples.SQLNHibernateOutboxEF.Receiver";
using (ReceiverDataContext ctx = new ReceiverDataContext())
{
ctx.Database.Initialize(true);
}
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
hibernateConfig.SetProperty("default_schema", "receiver");
BusConfiguration busConfiguration = new BusConfiguration();
busConfiguration.UseSerialization<JsonSerializer>();
busConfiguration.EndpointName("Samples.SQLNHibernateOutboxEF.Receiver");
#region ReceiverConfiguration
busConfiguration
.UseTransport<SqlServerTransport>()
.UseSpecificConnectionInformation(
EndpointConnectionInfo.For("Samples.SQLNHibernateOutboxEF.Sender").UseSchema("sender"))
.DefaultSchema("receiver");
busConfiguration
.UsePersistence<NHibernatePersistence>()
.RegisterManagedSessionInTheContainer();
busConfiguration.EnableOutbox();
#endregion
using (Bus.Create(busConfiguration).Start())
{
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
}
示例14: AsyncMain
static async Task AsyncMain()
{
Configuration hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
#region NHibernate
hibernateConfig.SetProperty("default_schema", "receiver");
#endregion
ModelMapper mapper = new ModelMapper();
mapper.AddMapping<OrderMap>();
hibernateConfig.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities());
new SchemaExport(hibernateConfig).Execute(false, true, false);
#region ReceiverConfiguration
EndpointConfiguration endpointConfiguration = new EndpointConfiguration();
endpointConfiguration.SendFailedMessagesTo("error");
endpointConfiguration.AuditProcessedMessagesTo("audit");
endpointConfiguration.EnableInstallers();
endpointConfiguration.UseTransport<SqlServerTransport>()
.DefaultSchema("receiver")
.UseSpecificSchema(e =>
{
switch (e)
{
case "error":
return "dbo";
case "audit":
return "dbo";
default:
string schema = e.Split(new[]
{
'.'
}, StringSplitOptions.RemoveEmptyEntries)[0].ToLowerInvariant();
return schema;
}
});
endpointConfiguration.UsePersistence<NHibernatePersistence>()
.UseConfiguration(hibernateConfig)
.RegisterManagedSessionInTheContainer();
#endregion
IEndpointInstance endpoint = await Endpoint.Start(endpointConfiguration);
try
{
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
finally
{
await endpoint.Stop();
}
}
示例15: AsyncMain
static async Task AsyncMain()
{
Console.Title = "Samples.SqlNHibernate.Sender";
var endpointConfiguration = new EndpointConfiguration("Samples.SqlNHibernate.Sender");
endpointConfiguration.SendFailedMessagesTo("error");
endpointConfiguration.EnableInstallers();
var hibernateConfig = new Configuration();
hibernateConfig.DataBaseIntegration(x =>
{
x.ConnectionStringName = "NServiceBus/Persistence";
x.Dialect<MsSql2012Dialect>();
});
hibernateConfig.SetProperty("default_schema", "sender");
#region SenderConfiguration
var transport = endpointConfiguration.UseTransport<SqlServerTransport>();
transport.DefaultSchema("sender");
transport.UseSpecificSchema(e =>
{
if (e == "error" || e == "audit")
{
return "dbo";
}
return null;
});
var persistence = endpointConfiguration.UsePersistence<NHibernatePersistence>();
persistence.UseConfiguration(hibernateConfig);
#endregion
var endpointInstance = await Endpoint.Start(endpointConfiguration)
.ConfigureAwait(false);
try
{
Console.WriteLine("Press enter to send a message");
Console.WriteLine("Press any key to exit");
while (true)
{
var key = Console.ReadKey();
Console.WriteLine();
if (key.Key != ConsoleKey.Enter)
{
return;
}
var orderId = new string(Enumerable.Range(0, 4).Select(x => letters[random.Next(letters.Length)]).ToArray());
var orderSubmitted = new OrderSubmitted
{
OrderId = orderId,
Value = random.Next(100)
};
await endpointInstance.Publish(orderSubmitted)
.ConfigureAwait(false);
}
}
finally
{
await endpointInstance.Stop()
.ConfigureAwait(false);
}
}