public void NpgsqlTableChanged(ListBox listBox, UiShow uiShow)
{
IEnumerable<object> enumerable;
using (NpgsqlConnection connection = new NpgsqlConnection(ConnectionString))
{
connection.Open();
string sql =
$"SELECT column_name, is_nullable, udt_name FROM INFORMATION_SCHEMA.COLUMNS\r\nWHERE table_catalog='{connection.Database}' AND table_schema='public' AND table_name='{listBox.SelectedItem}';";
enumerable = connection.Query(sql, null, null, true, null, null);
}
StringBuilder builder = new StringBuilder();
builder.AppendFormat("public class {0}{1}{{{1}", listBox.SelectedItem, Environment.NewLine);
foreach (dynamic obj2 in enumerable)
{
string columnName = (string)obj2.column_name;
bool isNullable = (bool)(obj2.is_nullable.ToUpper() == "YES");
string dataType = (string)obj2.udt_name;
builder.AppendLine(GenerateField(columnName, isNullable, dataType));
}
string @class = builder.Append("}").ToString();
uiShow.txtClass.Text = @class;
File.AppendAllText("models.cs", @class);
}
public void SQLConnSet_BtnConnClick(ConnSet connSet, UiShow uiShow)
{
using (SqlConnection connection = CreateConnection(connSet))
{
connection.Open();
uiShow.lbTableName.Items.Clear();
IEnumerable<object> enumerable = connection.Query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' ORDER BY TABLE_NAME ASC;", null, null, true, null, null);
uiShow.lbTableName.Items.AddRange((from d in enumerable select ((dynamic)d).TABLE_NAME).ToArray<object>());
}
}
public void MySqlConnSet_BtnConnClick(ConnSet connSet, UiShow uiShow)
{
StringBuilder sb = new StringBuilder();
foreach (var item in TableNames)
{
sb.AppendLine(GenerateCode(item as string));
}
System.IO.File.WriteAllText("ORM.cs", sb.ToString());
uiShow.lbTableName.Items.Clear();
uiShow.lbTableName.Items.AddRange(TableNames);
}
public void pgAdminConnSet_BtnConnClick(ConnSet connSet, UiShow uiShow)
{
using (NpgsqlConnection connection = CreateConnection(connSet))
{
connection.Open();
uiShow.lbTableName.Items.Clear();
string sql =
$"SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_catalog='{connection.Database}' AND table_schema='public' AND table_type='BASE TABLE' ORDER BY table_name ASC;";
IEnumerable<object> enumerable = connection.Query(sql, null, null, true, null, null);
uiShow.lbTableName.Items.AddRange((from d in enumerable select ((dynamic)d).table_name).ToArray<object>());
}
}
public void SqlLiteTableChanged(ListBox listBox, UiShow uiShow)
{
IEnumerable<object> enumerable;
using (SQLiteConnection connection = new SQLiteConnection(SqLiteConnStr.ToString()))
{
connection.Open();
string sql = $"PRAGMA table_info({listBox.SelectedItem})";
enumerable = connection.Query(sql, null, null, true, null, null);
}
StringBuilder builder = new StringBuilder();
builder.AppendFormat("public class {0}{1}{{{1}", listBox.SelectedItem, Environment.NewLine);
foreach (dynamic obj2 in enumerable)
{
string columnName = (string)obj2.name;
bool isNullable = (bool)(obj2.notnull == 0L);
string dataType = (string)obj2.type;
builder.AppendLine(GenerateField(columnName, isNullable, dataType));
}
uiShow.txtClass.Text = builder.Append("}").ToString();
}
public void ShowSqLiteTables(UiShow uiShow, string path)
{
if (uiShow != null)
{
SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder
{
DataSource = path,
};
SqLiteConnStr = builder;
using (SQLiteConnection connection = new SQLiteConnection(SqLiteConnStr.ToString()))
{
connection.Open();
uiShow.lbTableName.Items.Clear();
IEnumerable<object> enumerable =
connection.Query("SELECT tbl_name FROM sqlite_master WHERE TYPE='table' ORDER BY name ASC;",
null, null, true, null, null);
uiShow.lbTableName.Items.AddRange(
(from d in enumerable select ((dynamic)d).tbl_name).ToArray<object>());
}
}
}
public void SqlTableChanged(ListBox listBox, UiShow uiShow)
{
IEnumerable<object> enumerable;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string sql =
$"SELECT COLUMN_NAME, IS_NULLABLE, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='{listBox.SelectedItem}';";
enumerable = connection.Query(sql, null, null, true, null, null);
}
StringBuilder builder = new StringBuilder();
builder.AppendFormat("public class {0}{1}{{{1}", listBox.SelectedItem, Environment.NewLine);
foreach (dynamic obj2 in enumerable)
{
string columnName = (string)obj2.COLUMN_NAME;
bool isNullable = (bool)(obj2.IS_NULLABLE.ToUpper() == "YES");
string dataType = (string)obj2.DATA_TYPE;
builder.AppendLine(GenerateField(columnName, isNullable, dataType));
}
uiShow.txtClass.Text = builder.Append("}").ToString();
}
public void MySqlTableChanged(ListBox listBox, UiShow uiShow)
{
uiShow.txtClass.Text = GenerateCode(listBox.SelectedItem as string);
}