数据库表生成Model代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】数据库表生成Model

作者:郑岸以 / 发布于2014/10/8/ 756

WPF前台，目前支持SQL Server，配置文件里有Oracle的扩展（待完善）,SQl Server使用前需要在网络配置里开启TCP/IP


	public partial class MainWindow : Window
	 {
	 private static IDbConnection conn;
	 private CustomerElementConfiguration[] bb;
	 public MainWindow()
	 {
	 InitializeComponent();
	 }
	
	 private void comboBox1_DropDownOpened(object sender, EventArgs e)
	 {
	
	 }
	
	 private void comboBox1_SelectionChanged(object sender, SelectionChangedEventArgs e)
	 {
	 // 赋值表名
	 cbTable.Items.Clear();
	 string type = (comboBox2.SelectedItem as ComboBoxItem).Content.ToString();
	 string db = (comboBox1.SelectedItem as ComboBoxItem).Content.ToString();
	 string table = bb.First(item => item.Name == type).GetTable;
	 IDbCommand cmd= conn.CreateCommand();
	 cmd.CommandText = string.Format(table,db);
	 IDataReader reader = cmd.ExecuteReader();
	 while (reader.Read())
	 {
	 cbTable.Items.Add(new ComboBoxItem()
	 {
	 Content = reader["name"].ToString()
	 });
	 }
	 reader.Close();
	 }
	
	 private void comboBox2_SelectionChanged(object sender, SelectionChangedEventArgs e)
	 {
	 string server = this.tbServer.Text;
	 string port = this.tbPort.Text;
	 string userid = this.tbUser.Text;
	 string pwd = this.tbPwd.Text;
	 if (string.IsNullOrWhiteSpace(server) || string.IsNullOrWhiteSpace(port) || string.IsNullOrWhiteSpace(userid))
	 {
	 MessageBox.Show("填写完左面的信息先！");
	 return;
	 }
	 try
	 {
	 if (conn != null && conn.State == ConnectionState.Open)
	 {
	 // 先关闭 链接数据库
	 conn.Close();
	 conn.Dispose();
	 }
	 string type=(comboBox2.SelectedItem as ComboBoxItem).Content.ToString();
	 string db=bb.First(item=>item.Name==type).ConnStr;
	 string conStr = string.Format(db, server, port, userid, pwd);
	 conn =ConnectionFactory.CreateConnection(type,conStr);
	 conn.Open();
	
	 // 加载数据库名称
	 comboBox1.Items.Clear();
	 IDbCommand cmd = conn.CreateCommand();
	 cmd.CommandText = bb.First(item => item.Name == type).GetDb;
	 IDataReader reader = cmd.ExecuteReader();
	 while (reader.Read())
	 {
	 comboBox1.Items.Add(new ComboBoxItem()
	 {
	 Content = reader["name"].ToString()
	 });
	 }
	 reader.Close();
	 }
	 catch (Exception ex)
	 {
	 MessageBox.Show(ex.Message);
	 }
	 }
	
	 private void Window_Closed(object sender, EventArgs e)
	 {
	 if (conn != null && conn.State == ConnectionState.Open)
	 {
	 // 先关闭 链接数据库
	 conn.Close();
	 conn.Dispose();
	 }
	 }
	
	 private void cbTable_SelectionChanged(object sender, SelectionChangedEventArgs e)
	 {
	 string type = (comboBox2.SelectedItem as ComboBoxItem).Content.ToString();
	 string column = bb.First(item => item.Name == type).GetColumn;
	 string db = (comboBox1.SelectedItem as ComboBoxItem).Content.ToString();
	 string table = (cbTable.SelectedItem as ComboBoxItem).Content.ToString();
	 string sql = string.Format(column, db, table);
	 string cla = GenerateHelper.GeneratePoco(conn, sql, table);
	 this.textBlock1.Text = cla;
	 }
	
	 private void Window_Loaded(object sender, RoutedEventArgs e)
	 {
	 try
	 {
	 CustomSection coll = (CustomSection)ConfigurationManager.GetSection("DbConfigGroup/DbConfig");
	 IEnumerable<CustomerElementConfiguration> aa = coll.CustomerElements.OfType<CustomerElementConfiguration>();
	 bb = aa.ToArray<CustomerElementConfiguration>();
	 // 加载数据库类型
	 foreach (var b in bb)
	 {
	 comboBox2.Items.Add(new ComboBoxItem {
	 Content=b.Name
	 });
	 }
	 }
	 catch (Exception ex)
	 {
	 MessageBox.Show(ex.Message);
	 }
	 }
	 }

试试其它关键字

　Model　　数据库表　

同语言下

可能有用的

郑岸以贡献的其它代码(8)