private static void BuildModel(string tableName) { //string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=DBTest;Data Source=.\SQL2008R2"; string dbname = "DBTest"; //string tableName = "SampleInt"; //string connStr2 = @"Data Source=.\SQL2008R2;Initial Catalog=DBTest;User ID=sa;Password=pass@word1;Persist Security Info=False;"; DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1"); ServerInfo serverInfo = new ServerInfo(link); IDatabaseInfo database = serverInfo.GetDatabase(dbname); ITableInfo tbInfo = null; foreach (ITableInfo tInfo in database.Tables) { if (tInfo.LowerName == tableName.ToLower()) { tbInfo = tInfo; break; } } DbTableCodeGen builder = new DbTableCodeGen(); string folder = builder.GenModelCode(tbInfo); //Process.Start(folder); }
private static void BuildTableAccess() { //string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=DBTest;Data Source=.\SQL2008R2"; string dbname = "DBTest"; string tableName = "df_TestUser"; DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1"); ServerInfo serverInfo = new ServerInfo(link); IDatabaseInfo database = serverInfo.GetDatabase(dbname); ITableInfo tbInfo = null; foreach (ITableInfo tInfo in database.Tables) { if (tInfo.LowerName == tableName.ToLower()) { tbInfo = tInfo; break; } } DbTableCodeGen gen = new DbTableCodeGen(); //string code = CodeGen.GenForTable("Model.cshtml", tbInfo); string code = gen.GenDataAccessCode("TestApp", tbInfo); string fileName = System.IO.Path.GetTempFileName(); System.IO.File.WriteAllText(fileName, code); Process.Start("notepad.exe", fileName); }