MsSQLContext factory(IUnityContainer container)
{
var db = new MsSQLContext(@"test");
return(db);
// db.Database.Connection.Open();
//var tables = db.Database.Connection.GetSchema("tables");
//if (false)
// foreach (DataRow row in tables.Rows)
// {
// Console.WriteLine(string.Join("\t", row.ItemArray));
// var tablename = row.ItemArray[2] as string;
// //var colums = db.Database.Connection.GetSchema("Columns");
// //DataTable myDataTable = db.Database.Connection.GetSchema(
// // "Columns", new string[] { tablename });
// Console.WriteLine(tablename);
// //foreach (DataColumn column in myDataTable.Columns)
// // Console.WriteLine(string.Format("\t{0}\t{1}\t", column.Caption, column.DataType.ToString()));
// Console.WriteLine();
// Console.ReadLine();
// }
var colums = db.Database.Connection.GetSchema("Columns");
foreach (DataColumn column in colums.Columns)
{
Console.WriteLine(string.Format("\t{0}\t{1}\t", column.Caption, column.DataType.ToString()));
}
Console.ReadKey();
var tables = colums.Rows.Cast <DataRow>().Select(SchemaToEFColumn).GroupBy(t => new { t.TableName, t.TableSchema }).ToArray();
foreach (var group in tables)
{
var tablename = group.Key.TableName;
Console.WriteLine(tablename);
foreach (var row in group)//.Select(row=>new { ColumnName = row.ItemArray[3], }))
{
Console.Write("\t");
Console.WriteLine(JsonConvert.SerializeObject(row));
}
Console.WriteLine();
Console.ReadKey();
}
db.Database.Connection.Close();
return(db);
}
MsSQLContext factory(IUnityContainer container)
{
var db = new MsSQLContext(@"test");
return db;
// db.Database.Connection.Open();
//var tables = db.Database.Connection.GetSchema("tables");
//if (false)
// foreach (DataRow row in tables.Rows)
// {
// Console.WriteLine(string.Join("\t", row.ItemArray));
// var tablename = row.ItemArray[2] as string;
// //var colums = db.Database.Connection.GetSchema("Columns");
// //DataTable myDataTable = db.Database.Connection.GetSchema(
// // "Columns", new string[] { tablename });
// Console.WriteLine(tablename);
// //foreach (DataColumn column in myDataTable.Columns)
// // Console.WriteLine(string.Format("\t{0}\t{1}\t", column.Caption, column.DataType.ToString()));
// Console.WriteLine();
// Console.ReadLine();
// }
var colums = db.Database.Connection.GetSchema("Columns");
foreach (DataColumn column in colums.Columns)
Console.WriteLine(string.Format("\t{0}\t{1}\t", column.Caption, column.DataType.ToString()));
Console.ReadKey();
var tables = colums.Rows.Cast<DataRow>().Select(SchemaToEFColumn).GroupBy(t => new { t.TableName, t.TableSchema }).ToArray();
foreach (var group in tables)
{
var tablename = group.Key.TableName;
Console.WriteLine(tablename);
foreach (var row in group)//.Select(row=>new { ColumnName = row.ItemArray[3], }))
{
Console.Write("\t");
Console.WriteLine(JsonConvert.SerializeObject(row));
}
Console.WriteLine();
Console.ReadKey();
}
db.Database.Connection.Close();
return db;
}
public UserRepository(MsSQLContext context, IDistributedCache distributedCache) : base(context, distributedCache)
{
}
public GenericRepository(MsSQLContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public PatientRepositoryImpl(MsSQLContext context) : base(context)
{
}
public UnitOfWork(MsSQLContext _context, IDistributedCache _distributedCache)
{
context = _context;
distributedCache = _distributedCache;
}
public UserRepository(MsSQLContext context) : base(context)
{
}
public GenericRepository(MsSQLContext context, IDistributedCache distributedCache = null)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
this.distributedCache = distributedCache;
}
public GenericRepository(MsSQLContext context)
{
_context = context;
_dataset = _context.Set <T>();
}
public UnitOfWork(MsSQLContext _context)
{
context = _context;
}
private static void InitializeUserAndRoles(MsSQLContext context)
{
// init user and roles
}
public RefreshTokenRepository(MsSQLContext context) : base(context)
{
}
