Dapper Post Data

1-)

public IDbConnection Connection

{

get

{

return new SqlConnection(ConfigurationManager.ConnectionStrings[“myconnectstring”].ConnectionString);

}

}

2-)

using (IDbConnection cn = Connection)

{

cn.Open();

foreach (var item in userReports)

{

DynamicParameters objParm = new DynamicParameters();

objParm.Add(“@productCode”, item.ProductCode);

objParm.Add(“@productName”, item.ProductName);

objParm.Add(“@companyId”, item.CompanyId);

objParm.Add(“@message”, dbType: DbType.String, direction: ParameterDirection.Output,size:600);

cn.Execute(“rpt_InsertCategory”, objParm, commandType: CommandType.StoredProcedure);

string result= objParm.Get<string>(“message”);

if (result!=null && result!= “successfull”)

{

if (result.Length > 0)

{

return Json(“Error occurred. Error details: “ + result);

}

}

}

cn.Close();

}

3-)

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create PROCEDURE [dbo].[rpt_InsertCategory]

@productCode nvarchar(50) ,

@productName nvarchar(150) ,

@message varchar(600) output

as

begin

SET NOCOUNT ON;

set @message=’successfull’

— -bla

— bla

end