public IEnumerable<MemberDetails> GetallMemberlist(int pageIndex, int pageSize) { string Location = "6,3"; string[] loc = Location.Split(','); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[1] { new DataColumn("CategoryID", typeof(int)) }); foreach (string s in loc) { dt.Rows.Add(s); } var para = new DynamicParameters(); para.Add("@PageIndex", pageIndex); para.Add("@StateIdTable", dt); para.Add("@PageSize", pageSize); var employees = con.Query<MemberDetails>("GetCustomersPageWise", para,commandType: CommandType.StoredProcedure); return employees; }
System.NotSupportedException: 'The member StateIdTable of type System.Data.DataTable cannot be used as a parameter value'
how to use dapper under 3 parameter 2 parameter normal value and one parameter is table parameter both of using stored procedure
para.Add("@StateIdTable", dt.AsTableValuedParameter());
SqlMapper
Dapper
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)