public OracleSchemaTest() { const string connectionStringName = "OracleELinq"; //DbConfiguration.InitializeDLinq<System.Data.Linq.Binary>(); if (!DbConfiguration.Items.TryGetValue(connectionStringName, out dbConfiguration)) { dbConfiguration = DbConfiguration.Configure(connectionStringName) .SetSqlLogger(() => new SqlLog(Console.Out)) ; } DataTable tb = null; using (var conn = dbConfiguration.DbProviderFactory.CreateConnection()) { conn.ConnectionString = dbConfiguration.ConnectionString; conn.Open(); tb = conn.GetSchema("DATATYPES", null); } tb.WriteXml(Console.Out); var items = tb.Rows.Cast <DataRow>().Select(p => p["TypeName"].ToString()).ToArray(); foreach (DataRow item in tb.Rows) { Console.WriteLine(string.Format("TypeName:{0},ProviderDbType:{1},DataType:{2}" , item["TypeName"] , item["ProviderDbType"] , item["DataType"])); } }
public DLinqConnection() { const string connectionStringName = "Northwind"; //DbConfiguration.InitializeDLinq<System.Data.Linq.Binary>(); if (!DbConfiguration.Items.TryGetValue(connectionStringName, out dbConfiguration)) { dbConfiguration = DbConfiguration.Configure(connectionStringName) .SetSqlLogger(() => new SqlLog(Console.Out)) .AddFromAssemblyOf <NLite.Data.Test.LinqToSql.Customers>(p => p.HasAttribute <System.Data.Linq.Mapping.TableAttribute>(false)); } var customerMapper = dbConfiguration.GetClass <Customers>(); Assert.IsNotNull(customerMapper); var orderMapper = dbConfiguration.GetClass <Orders>(); Assert.IsNotNull(orderMapper); var employeesMapper = dbConfiguration.GetClass <Employees>(); Assert.IsNotNull(employeesMapper); var employeeTerritoriesMapper = dbConfiguration.GetClass <EmployeeTerritories>(); Assert.IsNotNull(employeeTerritoriesMapper); var ProductsMapper = dbConfiguration.GetClass <Products>(); Assert.IsNotNull(ProductsMapper); var SuppliersMapper = dbConfiguration.GetClass <Suppliers>(); Assert.IsNotNull(SuppliersMapper); var TerritoriesMapper = dbConfiguration.GetClass <Territories>(); Assert.IsNotNull(TerritoriesMapper); }
private static void AddMainDb(string container, string dbConnectionString, string providerName, string entityAssmbly, bool isFromDB, string defaultContainer, ILoggerFactory loggerFactory = null) { //var entityAssmbly = config.GetSection("appSettings").GetValue<string>("ENTITY_ASSMBLY"); DbContextOption dbContextOption = null; if (isFromDB) { dbContextOption = GetMainDbContextOption(new DbContextOption { Container = container, ConnectionString = dbConnectionString, ModuleAssemblyName = entityAssmbly, Provider = providerName, LogggerFactory = loggerFactory }, defaultContainer); //dbContextOption.ModuleAssemblyName = entityAssmbly; } else { dbContextOption = new DbContextOption { Container = defaultContainer, ConnectionString = dbConnectionString, ModuleAssemblyName = entityAssmbly, Provider = providerName, LogggerFactory = loggerFactory }; } DbConfiguration.Configure(dbContextOption); }
public void Configure3() { var setting = System.Configuration.ConfigurationManager.ConnectionStrings["Northwind"]; var factory = DbProviderFactories.GetFactory(setting.ProviderName); var conn = factory.CreateConnection(); conn.ConnectionString = setting.ConnectionString; var cfg = DbConfiguration.Configure(conn); Assert.AreEqual(setting.ConnectionString, cfg.ConnectionString); Assert.IsNotNull(cfg.ConnectionString); //数据库连接字符串 Assert.IsNotNull(cfg.DbProviderName); // Assert.IsNotNull(cfg.DbProviderFactory); //DbProviderFactory Assert.IsNotNull(cfg.Dialect); //数据库方言 var db = cfg.CreateDbContext(); Assert.IsNotNull(db); Assert.IsNotNull(db.Connection); Assert.IsFalse(db.Connection.State == System.Data.ConnectionState.Open); //Assert.AreEqual(db.Connection, conn); conn.Open(); db.Dispose(); db = null; Assert.IsTrue(conn.State == System.Data.ConnectionState.Open); conn.Close(); }
public void TestEntityModelMapping() { var dbConfiguration = DbConfiguration.Configure("Northwind").AddClass <Index>(); var mapping = dbConfiguration.GetClass <Index>(); Assert.AreEqual("tbIndex", mapping.TableName); }
static UCDbContext() { dbConfiguration = DbConfiguration .Configure(connectionStringName) .SetSqlLogger(() => SqlLog.Debug) .AddFromAssemblyOf <UCDbContext>(t => t.HasAttribute <TableAttribute>(false)) ; }
//[ExpectedException(typeof(MappingException))] public void NoMappingTest() { DbConfiguration.Items.Clear(); var db = DbConfiguration .Configure("Northwind") //不映射.AddClass<Customer>(); .CreateDbContext(); var customers = db.Set <Customer>();//报异常:ORMappingException }
public void MappingTest() { var db = DbConfiguration .Configure("Northwind") .AddClass <Customer>() .CreateDbContext(); var customers = db.Set <Customer>(); Assert.IsNotNull(customers); }
public void SetSQLLog() { var db = DbConfiguration .Configure("Northwind") //.AddClass<Customer>() .SetSqlLogger(() => new SqlLog(Console.Out)) .CreateDbContext(); var customers = db.Set <Customer>(); var c = customers.FirstOrDefault(); c.Dump(); }
public SqlServerSchema() { const string connectionStringName = "Northwind"; //DbConfiguration.InitializeDLinq<System.Data.Linq.Binary>(); if (!DbConfiguration.Items.TryGetValue(connectionStringName, out dbConfiguration)) { dbConfiguration = DbConfiguration.Configure(connectionStringName) .SetSqlLogger(() => new SqlLog(Console.Out)) ; } }
public DDLTest() { const string connectionStringName = "ELinq"; //DbConfiguration.InitializeDLinq<System.Data.Linq.Binary>(); if (!DbConfiguration.Items.TryGetValue(connectionStringName, out dbConfiguration)) { dbConfiguration = DbConfiguration.Configure(connectionStringName) .SetSqlLogger(() => new SqlLog(Console.Out)) .AddFromAssemblyOf <ELinq.DDLTest.ElinqToSql.Models.Customers>(t => t.HasAttribute <TableAttribute>(false)); } }
private static void AddRouteDb(string defaultContainer, string defaultDbConnectionString, string defaultProviderName, string defaultEntityAssmbly, ILoggerFactory loggerFactory = null) { var list = GetRouteDbContextOptions(new DbContextOption { Container = defaultContainer, ConnectionString = defaultDbConnectionString, ModuleAssemblyName = defaultEntityAssmbly, Provider = defaultProviderName, LogggerFactory = loggerFactory }); if (list.Count() > 0) { //list.ForEach(p => { p.ModuleAssemblyName = defaultEntityAssmbly; }); DbConfiguration.Configure(list); } }
public static DbConfiguration GetOrCreateDbConfiguration(string dbSourceName, bool validateSchema) { if (!Acl.Data.Configuration.DbConfiguration.Items.TryGetValue(dbSourceName, out DbConfiguration cfg)) { // 获取 exe.config 中的连接字符串。 var connectSettings = ConfigurationManager.ConnectionStrings.OfType <ConnectionStringSettings>() .Where(p => p.Name == dbSourceName).FirstOrDefault(); if (connectSettings != null) { cfg = DbConfiguration.Configure(dbSourceName); } else { var dataSrc = DataSources.Values.Where(p => p.Name == dbSourceName).FirstOrDefault(); if (dataSrc == null) { throw new Exception(string.Format("没有找到 DataSource={0} 的配置 。", dbSourceName)); } var urlFixed = dataSrc.Url; if (dataSrc.Driver.Contains("SQLite")) { urlFixed = HelperTools.FixSQLiteDbUrl(dataSrc.Url); } cfg = DbConfiguration.Configure(urlFixed, dataSrc.Driver, dbSourceName); } // 设置表名复数策略 cfg.SetMappingConversion(MappingConversion.Plural); // 添加DB表映射。 if (DataSources.ContainsKey(dbSourceName)) { DataSources[dbSourceName].TableDescriptors.ForEach(p => cfg.ModelBuilder.AddClass(p.Value.EntityType)); } // 验证Schema if (validateSchema) { cfg.ModelBuilder.ValidateSchema(); } } return(cfg); }
private static void AddRouteDb(string defaultContainer, string defaultDbConnectionString, string defaultProviderName, ILoggerFactory loggerFactory = null) { var option = new DbContextOption { Container = defaultContainer, ConnectionString = defaultDbConnectionString, Provider = defaultProviderName, LogggerFactory = loggerFactory }; var list = option.DbContextOption(GetDefRouteDbContextOptions(option)); if (list.Count() > 0) { DbConfiguration.Configure(list); } }
public void Configure2() { var setting = System.Configuration.ConfigurationManager.ConnectionStrings["Northwind"]; var cfg = DbConfiguration.Configure(setting.ConnectionString, setting.ProviderName); //Assert.AreEqual(setting.ConnectionString, cfg.Name); Assert.IsNotNull(cfg.ConnectionString); //数据库连接字符串 Assert.IsNotNull(cfg.DbProviderName); // Assert.IsNotNull(cfg.DbProviderFactory); //DbProviderFactory Assert.IsNotNull(cfg.Dialect); //数据库方言 var db = cfg.CreateDbContext(); Assert.IsNotNull(db); Assert.IsNotNull(db.Connection); Assert.IsFalse(db.Connection.State == System.Data.ConnectionState.Open); }
static Northwind() { if (!DbConfiguration.Items.TryGetValue(connectionStringName, out dbConfiguration)) { dbConfiguration = DbConfiguration .Configure(connectionStringName) // .SetSqlLogger(() =>SqlLog.Trace) .SetMappingConversion(MappingConversion.Plural) .AddClass <Customer>() //注册映射类 .AddClass <Order>() //注册映射类 .AddClass <OrderDetail>(p => { p.TableName("Order Details"); }) //注册映射类 .AddClass <Product>() //注册映射类 // .AddFile("Model\\Northwind.mapping.xml") ; } }
public void ConnectionConfigureTest() { var connectionStringName = "Northwind"; var cfg = DbConfiguration .Configure(connectionStringName)//ConnectionStringName by config file ; Assert.AreEqual(connectionStringName, cfg.Name); Assert.IsNotNull(cfg.ConnectionString); //数据库连接字符串 Assert.IsNotNull(cfg.DbProviderName); // Assert.IsNotNull(cfg.DbProviderFactory); //DbProviderFactory Assert.IsNotNull(cfg.Dialect); //数据库方言 var db = cfg.CreateDbContext(); Assert.IsNotNull(db); Assert.IsNotNull(db.Connection); Assert.IsFalse(db.Connection.State == System.Data.ConnectionState.Open); }
public void Test1() { var appsettings = @" { 'spring': { 'application': { 'name': 'myName' }, }, 'skynet': { 'cloud': { 'filepath': 'c:/doc', } } }"; var path = TestHelpers.CreateTempFile(appsettings); string directory = Path.GetDirectoryName(path); string fileName = Path.GetFileName(path); ConfigurationBuilder configurationBuilder = new ConfigurationBuilder(); configurationBuilder.SetBasePath(directory); configurationBuilder.AddJsonFile(fileName); var config = configurationBuilder.Build(); DbConfiguration.Configure(dbContextOption); IFileHandler fileHandler = new FileHandler(config, GetLoggerFactory().CreateLogger <FileHandler>()); ICodeGenService codeGenService = new CodeGenService(fileHandler, GetLoggerFactory().CreateLogger <CodeGenService>()); GenConfig genConfig = new GenConfig() { Author = "magic.s.g.xie", Comments = "Á÷³ÌÒµÎñ", Email = "*****@*****.**", Namespace = "UWay.Skynet.Cloud", ModuleName = "Uflow", TablePrefix = "UF_" }; codeGenService.GeneratorCode(genConfig); }
static void Main() { try { Process instance = GetRunningInstance(); if (instance == null) { //处理未捕获的异常 Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException); //处理UI线程异常 Application.ThreadException += Application_ThreadException; //处理非UI线程异常 AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException; Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); DbConfiguration cfg = DbConfiguration .Configure("Scheduler") .AddClass <Appointment>() .AddClass <AppointmentLabel>() .AddClass <AppointmentDisplay>(); MainLogger.Instance.Trace("开始运行"); Application.Run(new MainForm()); } else { HandleRunningInstance(instance); } } catch (Exception ex) { MainLogger.Instance.Trace(ex.Message); //提示窗体 new ErrorForm().ShowDialog(); } }
private static void SetConfig(DbConfiguration cfg) { cfg.Configure <AutomobileModel>(opts => opts.SetPrimaryKey(a => a.Vin)); }
public void Test1() { //var path = AppDomain.CurrentDomain.RelativeSearchPath ?? AppDomain.CurrentDomain.BaseDirectory; //var dir = new DirectoryInfo(path); //var files = dir.GetFiles("*.service.*"); //foreach (var item in files) //{ // Console.WriteLine(item.Name); //} //Regex regex = new Regex("*.Service"); //var serviceAssemblys = RuntimeHelper.GetServicesAssembly(); //var item = serviceAssemblys.FirstOrDefault().GetName(true).Name+"."; //var interfaceAssembly = RuntimeHelper.GetAssembly(item); //Assert.NotNull(interfaceAssembly); var appsettings = @" { 'spring': { 'application': { 'name': 'myName' }, }, 'skynet': { 'cloud': { 'filepath': 'c:/doc', } } }"; var path = TestHelpers.CreateTempFile(appsettings); string directory = Path.GetDirectoryName(path); string fileName = Path.GetFileName(path); ConfigurationBuilder configurationBuilder = new ConfigurationBuilder(); configurationBuilder.SetBasePath(directory); configurationBuilder.AddJsonFile(fileName); var config = configurationBuilder.Build(); var provider = GetServiceProvider(); DbContextOption dbContextOption = new DbContextOption() { ConnectionString = "data source=192.168.15.117:1521/ora10;user id=test_cnoap;password=test_cnoap;Pooling=true;Max Pool Size=100;Min Pool Size=5;", Container = "1", LogggerFactory = provider.GetService <ILoggerFactory>(), MappingFile = "uway.cdma.normal.mapping.xml", Provider = DbProviderNames.Oracle_Managed_ODP }; DbConfiguration.Configure(dbContextOption); INeService service = provider.GetService <INeService>(); CompositeFilterDescriptor filter = new CompositeFilterDescriptor(); filter.LogicalOperator = FilterCompositionLogicalOperator.Or; FilterDescriptor filterDescriptor = new FilterDescriptor() { Member = "NeName", Operator = FilterOperator.Contains, Value = "╣─┬Ц" }; FilterDescriptor filterDescriptor2 = new FilterDescriptor() { Member = "NeName", Operator = FilterOperator.Contains, Value = "ол╔й" }; filter.FilterDescriptors.Add(filterDescriptor); filter.FilterDescriptors.Add(filterDescriptor2); var bts = service.GetNeBtsByCondition(NetType.CDMA, new List <IFilterDescriptor>() { filter }); Assert.NotNull(bts); Assert.True(bts.Count() > 0); DataSourceRequest request = new DataSourceRequest(); request.Page = 1; request.PageSize = 10; request.Filters = new List <IFilterDescriptor>() { filter }; request.Sorts = new List <SortDescriptor>() { new SortDescriptor() { Member = "NeName", SortDirection = System.ComponentModel.ListSortDirection.Ascending } }; var page = service.BtsPage(NetType.CDMA, request); Assert.True(page.Total > 0); var btsResult = service.GetNeBtsPageByCondition(NetType.CDMA, request); Assert.True(btsResult.Total > 0); }
public BaseDbContext(string Provider, string ConnectString) : base(DbConfiguration.Configure(ConnectString, Provider)) { this.RegisterMapping(base.DbConfiguration); }