view and post data EF core

view and post data EF core - no model

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);

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")

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
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")