connection.string is showing closed

yash patel

below wis the code

everything is fine model state is also getting treue but when it is checking the connection string at that time why the connection string is showing closed.

I want to insert details using stored procedure.

static string ConnectionString = "Data Source=DESKTOP-O4FO06T/SQL2017;Initial Catalog=practical;Integrated Security=True";

public static int InsertUserDetails( UserModel obj )

{

int rowAffected = 0;

using (IDbConnection con = new SqlConnection(ConnectionString))

{

if (con.State == ConnectionState.Closed)

con.Open();

DynamicParameters parameters = new DynamicParameters();

parameters.Add("@Name", obj.Name, DbType.String);

parameters.Add("@Gender", obj.Gender, DbType.String);

parameters.Add("@Address", obj.Address, DbType.String);

parameters.Add("@Mobile", obj.Mobile, DbType.String);

rowAffected = con.Execute("InsertUserDetails", parameters, commandType: CommandType.StoredProcedure);

}

return rowAffected;

}

2 Replies

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

Sachin Singh5y ago
why are you making dapper complicated,
just provide required parameters and execute the store procedure.
var procedure = "InsertUserDetails";
   var values = new { Name=obj.Name,Gender=Obj.gender,......}; // these are parameters
   var results = connection.Query(procedure, values, commandType: CommandType.StoredProcedure).ToList();
Amit Gupta5y ago
If you haven't any open connection while querying, Dapper will open the connection and execute the query. It will handle all your stuffs behind the scenes. https://dapper-tutorial.net/knowledge-base/54388895/how-does-dapper-execute-query-without-explicitly-opening-connection-#:~:text=Dapper%20provide%20two%20ways%20to,Dapper%20will%20close%20the%20connection.