How to create dynamic model using created dynamic table?

Question

i Wan to create dynamic model using created dynamic table please give me the best solutions?

Siddharth Gajbhiye · Answer

Hello Rahul Please refer the below link https://stackoverflow.com/questions/29676230/how-to-use-a-dynamic-model-to-create-a-dynamic-table it might slove your problem Thanku

Laxmidhar Sahoo · Answer

hi Thanks Whether the webclient respence or not if yes so Can you show me the data structure that the webclient respence.

Rahul Kumar · Answer

Hi Laxmidhar, Thanks for giving me response, Actualy what i want, i will explane you breifly featchin data from API like-- public void CreateDynamicTable() { using (WebClient apiData = new WebClient()) { var json = apiData.DownloadString("http://localhost:64086/api/us/Values/GetAllData"); string valueOriginal = Convert.ToString(json); DataTable DtValue = ConvertJsonToDatatable(valueOriginal); string createTableScript = CreateTABLEQuery("TestTable", DtValue); DropIfExitTable("TestTable"); ExuecuteSqlQuery(createTableScript); SqlCommand insert = CreateInsertQuery("TestTable", DtValue); BatchInsertUpdate(DtValue, insert, 10); } } using given data i create dynamic table like - public static string CreateTABLEQuery(string tableName, DataTable table) { string sqlsc; sqlsc = "CREATE TABLE " + tableName + "("; for (int i = 0; i { sqlsc += "
 [" + table.Columns[i].ColumnName + "] "; string columnType = table.Columns[i].DataType.ToString(); switch (columnType) { case "System.Int32": sqlsc += " int "; break; case "System.Int64": sqlsc += " bigint "; break; case "System.Int16": sqlsc += " smallint"; break; case "System.Byte": sqlsc += " tinyint"; break; case "System.Decimal": sqlsc += " decimal "; break; case "System.DateTime": sqlsc += " datetime "; break; case "System.Boolean": sqlsc += " bit "; break; case "System.String": default: sqlsc += string.Format(" nvarchar({0}) ", table.Columns[i].MaxLength == -1 ? "max" : table.Columns[i].MaxLength.ToString()); break; } if (table.Columns[i].AutoIncrement) sqlsc += " IDENTITY(" + table.Columns[i].AutoIncrementSeed.ToString() + "," + table.Columns[i].AutoIncrementStep.ToString() + ") "; if (!table.Columns[i].AllowDBNull) sqlsc += " NOT NULL "; sqlsc += ","; } return sqlsc.Substring(0, sqlsc.Length - 1) + "
)"; } now using this table i want to crate dynamic model whenever API will be change automatic model will be change, is it possible?

Laxmidhar Sahoo · Answer

1-I f data is taken from database and dynamilly create html table bellow is the link https: //www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/ 2-Otherwise if you want to create a table in database dynamically bellow is the code . protected void CreateTable( object sender, EventArgs e) { string query = "IF OBJECT_ID('dbo.CustomersTest', 'U') IS NULL " ; query += "BEGIN " ; query += "CREATE TABLE [dbo].[CustomersTest](" ; query += "[CustomerId] INT IDENTITY(1,1) NOT NULL CONSTRAINT pkCustomerId PRIMARY KEY," ; query += "[Name] VARCHAR(100) NOT NULL," ; query += "[Country] VARCHAR(50) NOT NULL" ; query += ")" ; query += " END" ; string constr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } 3- If something else please convey with more examples Thanks

Rahul Kumar · Answer

i want to create dynamic model using dynamic table? for example- I have a dynamic table properties like Id, Name, Salary this table creating by API when api is change properties authomatic change like id, name, salary, address using this i want to create dynamic model.

Laxmidhar Sahoo · Answer

hi Would you like to create dynamic object from datatable or something different