private static void DataRows(DataRowCollection collection)
{
foreach (DataRow row in collection)
{
var type = row.ItemArray[12];
string name = row.ItemArray[0].ToString();
Propertyes.CreateProperty(type.ToString(), name);
}
}
public static string GetColumnNames(string connectionName)
{
Tools tools = new Tools();
string namespaces = tools.Namespacer();
string pathas = tools.Paths();
ConfigurationManager.ConnectionStrings[connectionName].ToString();
StringBuilder builder = new StringBuilder();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionName].ToString()))
{
connection.Open();
string ClassName = string.Empty;
foreach (var item in Tables.ListTables(connectionName))
{
SqlCommand sqlCmd = connection.CreateCommand();
if (item.Contains(" "))
{
continue;
}
else if (item.Contains("__EFMigrationsHistory"))
{
continue;
}
ClassName = item;
sqlCmd.CommandText = _SELECT + item + _WHERE;
builder.Append("using System;\n");
builder.Append("\n\n");
builder.Append("namespace " + namespaces + ".Models \n{\n");
builder.Append("\n public class " + ClassName + " {\n\n");
sqlCmd.CommandType = CommandType.Text;
var sqlDR = sqlCmd.ExecuteReader();
var dataTable = sqlDR.GetSchemaTable();
foreach (DataRow row in dataTable.Rows)
{
var type = row.ItemArray[12];
string name = row.ItemArray[0].ToString();
string mss = Propertyes.CreateProperty(type.ToString(), name);
builder.Append(" " + mss + "\n");
}
builder.Append("\n}\n}");
if (!Directory.Exists(pathas + "/Models"))
{
Directory.CreateDirectory(pathas + "/Models");
}
Save(pathas + "/Models/", ClassName, builder.ToString());
builder.Clear();
sqlCmd.Clone();
}
}
string ms = builder.ToString();
return(builder.ToString());
}
