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