view and post data EF core - no model

Question

In MVC 2022 I create tables in the database by calling stored procedures the number of columns can vary, I would like too show them in a grid and save the cell data in a Submit -post. Is there a recommended way too do so without using 3rd party components? The tables dont have models.

   command.CommandText = "SELECT * FROM tableName";
    var reader = await command.ExecuteReaderAsync();

    DataTable LiveTab = new DataTable();
    LiveTab.Load(reader);
    return View(LiveTab);

Sachin Singh · Answer

EF is an ORM means object to relational data mapper, so model is obvious. But, in your example you are using plain ADO.NET, for this you can create a method, for verying parameters (column) as public DataTable RunSP_ReturnDT(string procedureName, List parameters, string connectionString) { DataTable dtData = new DataTable(); using (SqlConnection sqlConn = new SqlConnection(connectionString)) { using (SqlCommand sqlCommand = new SqlCommand(procedureName, sqlConn)) { sqlCommand.CommandType = CommandType.StoredProcedure; if (parameters != null) { sqlCommand.Parameters.AddRange(parameters.ToArray()); } using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand)) { sqlDataAdapter.Fill(dtData); } } } return dtData; } call the method as var params= new List () { new SqlParameter() { ParameterName = "@firstParam" , // Defining Name SqlDbType = SqlDbType.Int, // Defining DataType Direction = ParameterDirection.Input, // Setting the direction Value= "the value" }, new SqlParameter() { ParameterName = "@secondparam" , // Defining Name SqlDbType = SqlDbType.Int, // Defining DataType Direction = ParameterDirection.Input, // Setting the direction Value= "the value" } } ; var dt=RunSP_ReturnDT( "yr procedure name" ,params, "connection string" )