private DataConnection CreateDataConnection(string connectionString, MappingSchema schema, TimeSpan timeout) { var connection = SqlServerTools.CreateDataConnection(connectionString); connection.AddMappingSchema(schema); connection.CommandTimeout = (int)timeout.TotalMilliseconds; return(connection); }
private DataConnection CreateDataConnection(SchemaInitializationCommand command) { var connectionString = _connectionStringSettings.GetConnectionString(command.ConnectionStringIdentity); var connection = SqlServerTools.CreateDataConnection(connectionString); connection.AddMappingSchema(command.MappingSchema); return(connection); }
private DataConnection CreateDataConnection(StorageDescriptor storageDescriptor) { var connectionString = _connectionStringSettings.GetConnectionString(storageDescriptor.ConnectionStringIdentity); var connection = SqlServerTools.CreateDataConnection(connectionString); connection.AddMappingSchema(storageDescriptor.MappingSchema); connection.CommandTimeout = (int)storageDescriptor.CommandTimeout.TotalMilliseconds; return(connection); }
public DataConnection CreateConnection(StorageDescriptorFeature storageDescriptorFeature) { var connectionString = _connectionStringSettings.GetConnectionString(storageDescriptorFeature.ConnectionStringName); var connection = SqlServerTools.CreateDataConnection(connectionString); connection.AddMappingSchema(storageDescriptorFeature.MappingSchema); connection.CommandTimeout = (int)TimeSpan.FromMinutes(30).TotalMilliseconds; return(connection); }
private DataConnection CreateDataConnection(IConnectionStringIdentity connectionStringIdentity, MappingSchema mappingSchema) { var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity); var dataConnection = SqlServerTools.CreateDataConnection(connectionString); dataConnection.AddMappingSchema(mappingSchema); dataConnection.CommandTimeout = 0; return(dataConnection); }
static void CreateTestDatabase(bool enforceCreate, string serverName) { Console.WriteLine("Creating database..."); using (var db = SqlServerTools.CreateDataConnection($"Server={serverName};Database=master;Trusted_Connection=True")) { if (!enforceCreate) { if (db.Execute <object>("SELECT db_id('PerformanceTest')") != null) { if (db.Execute <object>("SELECT OBJECT_ID('PerformanceTest.dbo.Setting', N'U')") != null) { if (db.GetTable <Setting>() .DatabaseName("PerformanceTest") .Any(s => s.Name == "DB Version" && s.Value == DatabaseVersion)) { return; } } } } db.Execute("DROP DATABASE IF EXISTS PerformanceTest"); db.Execute("CREATE DATABASE PerformanceTest"); } using (var db = new L2DB.L2DBContext()) { CreateTable(db, new[] { new Setting { Name = "DB Version", Value = DatabaseVersion } }); CreateTable(db, new[] { new Narrow { ID = 1, Field1 = 2 } }); CreateTable(db, Enumerable.Range(1, 1000000).Select(i => new NarrowLong { ID = i, Field1 = -i })); CreateTable(db, Enumerable.Range(1, 1000000).Select(i => new WideLong { ID = i, Field1 = -i, ByteValue = i % 2 == 0 ? null : (byte?)(i % Byte.MaxValue / 2), ShortValue = i % 2 == 0 ? null : (short?)(i % Int16.MaxValue / 2), IntValue = i % 2 == 1 ? null : (int?)(i % Int32.MaxValue - 1), LongValue = i % 2 == 0 ? null : (long?)(i * 2), StringValue = i % 2 == 0 ? null : new string(Enumerable.Range(0, 95).Select(n => (char)(n % 30 + (int)' ')).ToArray()), DateTimeValue = i % 2 == 1 ? null : (DateTime?)new DateTime(i), TimeValue = i % 2 == 1 ? null : (TimeSpan?)new TimeSpan(i), DecimalValue = i % 2 == 0 ? null : (decimal?)i, DoubleValue = i % 2 == 1 ? null : (double?)i, FloatValue = i % 2 == 0 ? null : (float?)i, })); } Console.WriteLine("Database created."); }
static IoC() { var builder = new Autofac.ContainerBuilder(); builder.RegisterModule(new MediatrModule()); builder.RegisterType <WebAPI>().AsSelf().SingleInstance(); builder.RegisterType <QueryWorker>().AsSelf().SingleInstance(); builder.RegisterType <ServiceImpl>().AsSelf().SingleInstance(); builder.Register(x => { var sqlString = "Data Source=.;Initial Catalog=BusinessModel;Integrated Security=true;User Id=POSSQL;Password=123456"; return(SqlServerTools.CreateDataConnection(sqlString)); } ).InstancePerLifetimeScope(); Default = builder.Build(); }
public void Test1() { Type modelType = GetModelType.Get(); string ConnectionString = "Server=(localdb)\\MSSQLLocalDB;Database=Northwind;Trusted_Connection=True;MultipleActiveResultSets=true"; using (DataConnection db = SqlServerTools.CreateDataConnection(ConnectionString)) { Type t = db.GetType(); MethodInfo mi = t.GetMethod("GetTable", new Type[] { }); MethodInfo miConstructed = mi.MakeGenericMethod(modelType); object[] args = { }; object res = miConstructed.Invoke(db, args); var res2 = db.GetTable <Category>().Select(s => s.CategoryName).ToArray(); var res3 = db.GetTable <Category>().Select(s => s.CategoryName).ToArray(); //var q = // from c in db.GetTable<Category>() // select c; //foreach (var category in q) //{ // Console.WriteLine("ID : {0}, Name : {1}", // category.CategoryID, // category.CategoryName); //} } // create an instance of the class //object destObject = Activator.CreateInstance(dynamicType); }
static void Main(string[] args) { Console.WriteLine("Hello World!"); string ConnectionString = "Server=(localdb)\\MSSQLLocalDB;Database=Northwind;Trusted_Connection=True;MultipleActiveResultSets=true"; using (var db = SqlServerTools.CreateDataConnection(ConnectionString)) { if (!db.IsDatabaseExists()) { db.CreateDatabase(); } var sp = db.DataProvider.GetSchemaProvider(); var dbSchema = sp.GetSchema(db); if (!dbSchema.Tables.Any(t => t.TableName == typeof(Category).Name)) { //no required table-create it db.CreateTable <Category>(); //db.CreateTable(); } } using (var db = SqlServerTools.CreateDataConnection(ConnectionString)) { var q = from c in db.GetTable <Category>() select c; foreach (var category in q) { Console.WriteLine("ID : {0}, Name : {1}", category.CategoryID, category.CategoryName); } } }
public DataConnection Open() => SqlServerTools.CreateDataConnection(Settings.ConnectionString, SqlServerVersion.v2012);
public Linq2Db() { db = SqlServerTools.CreateDataConnection(ConnectionString); }
public ISessionScope Open() { return(new Linq2DbSessionScope(SqlServerTools.CreateDataConnection(_connectionString))); }