public void LoadDatabaseSchema(DatabaseLink dbLink, ServerInfo srvInfo) { this.DBLink = dbLink; this.SrvInfo = srvInfo; this.DBName = dbLink.DatabaseName; this.Database = srvInfo.GetDatabase(this.DBName); LoadDbSchema(false); }
private static void BuildDBDoc() { //string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=ENTERPRISES_SUPERWORKFLOW;Data Source=.\SQL2008R2"; string dbname = "ENTERPRISES_SUPERWORKFLOW"; DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1"); ServerInfo serverInfo = new ServerInfo(link); IDatabaseInfo database = serverInfo.GetDatabase(dbname); DBDocBuilder builder = new DBDocBuilder(database); builder.Build(); }
public static void Add(DatabaseLink link) { var oldLink = (from p in Connections where p.ServerName == link.ServerName select p).FirstOrDefault(); if (oldLink != null) { Connections.Remove(oldLink); } Connections.Insert(0, link); Save(); }
static ConnectionSetting() { string filePath = Path.Combine(Environment.CurrentDirectory, "Settings\\" + FileName); if (File.Exists(filePath)) { string txt = File.ReadAllText(filePath); XElement config = XElement.Parse(txt); foreach (XElement el in config.Elements()) { DatabaseLink link = new DatabaseLink( EnumHelper.ParseEnum<DatabaseType>(el.Attribute("Type").Value), el.Attribute("ServerName").Value, el.Attribute("LoginName").Value, el.Attribute("LoginPassword").Value, (bool)el.Attribute("IsWindowsLogin")); link.SetDatabaseName(el.Attribute("DatabaseName").Value); Connections.Add(link); } } }
private void btnLogin_Click(object sender, EventArgs e) { this.cbServerType.Enabled = false; this.cbServerName.Enabled = false; this.rbWindows.Enabled = false; this.rbSQLServer.Enabled = false; this.txtLoginName.Enabled = false; this.txtPassword.Enabled = false; this.btnLogin.Enabled = false; this.btnOK.Enabled = false; this.cbDatabases.Enabled = false; var link = new DatabaseLink((DatabaseType)this.cbServerType.SelectedValue, this.cbServerName.Text, this.txtLoginName.Text, this.txtPassword.Text, rbWindows.Checked); this.DBLink = link; BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); worker.RunWorkerAsync(); }
private static void BuildDBAccess() { //Console.WriteLine("正在生成..."); var watch1 = Stopwatch.StartNew(); //string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=ENTERPRISES_SUPERWORKFLOW;Data Source=.\SQL2008R2"; string solutionName = "CK"; string dbname = "ENTERPRISES_SUPERWORKFLOW"; DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1"); ServerInfo serverInfo = new ServerInfo(link); IDatabaseInfo database = serverInfo.GetDatabase(dbname); SolutionBuilder sb = new SolutionBuilder(database, solutionName, dbname, link.ConnectionString); string errorStr = ""; if (!sb.Build(ref errorStr)) { Console.Write(errorStr); } Console.WriteLine("over!"); Console.WriteLine("{0} ", watch1.Elapsed); Console.ReadKey(); }
private static void TestAspnetForm(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; } } PageFormCodeGen builder = new PageFormCodeGen(); PageFormModel model = new PageFormModel(tbInfo); string folder = builder.Build(model); Process.Start(folder); }
private static void BuildProj() { //string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=NGB_ONLINE;Data Source=192.168.0.98"; string dbname = "NGB_ONLINE"; string tableName = "CoursePlan"; //string connStr2 = @"Data Source=192.168.0.98;Initial Catalog=NGB_ONLINE;User ID=sa;Password=pass@word1;Persist Security Info=False;"; DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @"192.168.0.98", dbname, "sa", "pass@word1"); ServerInfo serverInfo = new ServerInfo(link); IDatabaseInfo database = serverInfo.GetDatabase(dbname); List<ITableInfo> selTables = new List<ITableInfo>(); foreach (ITableInfo tInfo in database.Tables) { if (tInfo.LowerName == tableName.ToLower()) { selTables.Add(tInfo); break; } } List<IViewInfo> selViews = new List<IViewInfo>(); DbConsoleProjectBuilder builder = new DbConsoleProjectBuilder(); string folder = builder.Build(selTables, selViews, link.ConnectionString, "TestApp"); 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); }
/// <summary> /// 连接数据库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLink_Click(object sender, EventArgs e) { this.cbType.Enabled = false; this.txtDBName.Enabled = false; this.txtLoginName.Enabled = false; this.txtPassword.Enabled = false; this.btnLink.Enabled = false; this.DBLink = new DatabaseLink((DatabaseType)this.cbType.SelectedValue, this.txtDBName.Text, this.txtLoginName.Text, this.txtPassword.Text, false); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); worker.RunWorkerAsync(); }