Retreive record fro database using entity framework

Question

Hi i want to retrive a record from database using stored procedure by passing column name and column value as parameters.please send me complete code i nee it urgent.By using below code i am trying....

ravi kiran · Answer

Hi i need to do by using entity framework only....

Pradip Pandey · Answer

Hi Try in this way In DAL: public void GetDetail() { string connectionString = connectionstring; SqlConnection conn = new SqlConnection(connectionString); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = conn; sqlCmd.Connection.Open(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = [P_SelectTableDetail]; sqlCmd.Parameters.AddWithValue(@ID ID); SqlDataReader dr = sqlCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (dr.Read()) { strCaseFileName = dr[Detail].ToString(); } dr.Close(); } catch (ArgumentException ex) { throw new ArgumentException(ex.Message); } catch (SqlException ex) { if (ex.Number == 201) { throw ; } throw; } finally { conn.Close(); } } In BAL: public string GetDetail123(string caseId) { Document doc = new Document(); doc.CaseID = caseId; doc.GetDetail(); return doc.CaseFileName; } On Page Code behind: private string GetSubmittedCase() { DocManager docManager = new DocManager(); return docManager.GetDetail123(LabelCaseID.Text); } Hope it will help.