static void forming_nrw() { DbContextOptionsBuilder <mphContext> DbContextOptions = new DbContextOptionsBuilder <mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb")); mphDb sourceContext = new mphDb(DbContextOptions, "dbo", ApplicationLogging.LoggerFactory); sourceContext.forming_nrw(); }
static void testAdd() { // creating db context by "Create" method (for working with multiple schemas) DbContextOptionsBuilder <mphContext> op_o = new DbContextOptionsBuilder <mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb")); mphDb mphDbContext = new mphDb(op_o, "ukgram", ApplicationLogging.LoggerFactory); var ac = mphDbContext.getContext().accents_class.AsNoTracking().OrderBy(c => c.id).ToArray(); DbContextOptionsBuilder <mphContext> op = new DbContextOptionsBuilder <mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb2")); mphDb sourceContext = new mphDb(op, "ukgram", ApplicationLogging.LoggerFactory); sourceContext.testAddAccents_class(); }
private static void generateJson() { Console.WriteLine("Почекайте, будь ласка, генерується файл «dict.json»..."); // creating db context by DI mphDb service = p.container.GetService <mphDb>(); //DbContextOptionsBuilder<mphContext> op = new DbContextOptionsBuilder<mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb")); //mphDb service = new mphDb(op, "ukgram", ApplicationLogging.LoggerFactory); var o = service.getObj(); string s = JsonConvert.SerializeObject(o); File.WriteAllText(Path.Combine(Directory.GetCurrentDirectory(), "dict.json"), s, Encoding.Unicode); }
private static void copyContext() { // creating db context by "Create" method (for working with multiple schemas) DbContextOptionsBuilder <mphContext> op = new DbContextOptionsBuilder <mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb")); mphDb sourceContext = new mphDb(op, "ukgram", ApplicationLogging.LoggerFactory); //DbContextOptionsBuilder<mphContext> op2 = new DbContextOptionsBuilder<mphContext>().UseSqlServer(Configuration.GetConnectionString("gramSqlDb2")); //mphDb resultContext = new mphDb(op2, "ukgram", ApplicationLogging.LoggerFactory); Console.WriteLine("Почекайте, будь ласка, дані переносяться..."); //sourceContext.copyContextTo(resultContext); sourceContext.copyContextTo(p.container.GetService <mphDb>()); }