ismetertugral
10/13/2017 - 12:15 PM

C# EXEC Store Procedure

C# Database EXEC Store Procedure

using (var dbc = new B2BVERIEntities())
{
	dbc.Database.CommandTimeout = 120;
	string sql = "EXEC [dbo].[W_DISCOUNTLIST] @FRM ,@SPECODE,@BARKOD";
	Partial.SQLLoguEkle(sql);
	var stoklar = dbc.Database.SqlQuery<StokViewModels.Stok_Fiyat_Detayi>(sql,
		new SqlParameter("@FRM", Partial.Ayar("FRM")),
		new SqlParameter("@SPECODE", s),
		new SqlParameter("@BARKOD", urunstok.BARKOD)
		).ToList();
}