Stored Procedures in Entity FrameWork ASP.Net Web API

  var dataSet = new DataSet();

            using (var context = new DataBase())

            {

                using (var con = new SqlConnection(context.Database.Connection.ConnectionString))

                {

                    using (var command = new SqlCommand("Sample_proc", con))

                    {

                        command.CommandType = CommandType.StoredProcedure;

                        command.Parameters.AddWithValue("@empId", id);

                        using (var adapter = new SqlDataAdapter(command))

                        {

                            adapter.Fill(dataSet);

                        }

                    }

                }

  var item1 = dataSet.Tables[0].AsEnumerable().Select(x => new Role

                {

                    RoleId = Convert.ToInt16(x["RoleId"] == DBNull.Value ? null : x["RoleId"]),

                    RoleDescription = $"{x["RoleDescription"]}",

                    Display = Convert.ToBoolean(x["Display"] == DBNull.Value ? null : x["Display"]),

                    CreatedById = Convert.ToInt32(x["CreatedById"] == DBNull.Value ? null : x["CreatedById"]),

                    CreatedTime = Convert.ToDateTime(x["CreatedTime"] == DBNull.Value ? null : x["CreatedTime"]),

                    EditedById = Convert.ToInt32(x["EditedById"] == DBNull.Value ? null : x["EditedById"]),

                    EditedTime = Convert.ToDateTime(x["EditedTime"] == DBNull.Value ? null : x["EditedTime"]),

                    //RowId = (byte[])x["RowId"],

                    DisplayName = $"{x["DisplayName"]}"

                }).ToList();

                var item2 = dataSet.Tables[1].AsEnumerable().Select(x => new RoleCode

                {

                    RoleCode1 = $"{x["RoleCode"]}",

                    DeleteFlag = Convert.ToBoolean(x["DeleteFlag"] == DBNull.Value ? null : x["DeleteFlag"]),

                    EditFlag = Convert.ToBoolean(x["EditFlag"] == DBNull.Value ? null : x["EditFlag"]),

                    CreatedById = Convert.ToInt32(x["CreatedById"]),

                    CreatedTime = Convert.ToDateTime(x["CreatedTime"]),

                    EditedById = Convert.ToInt32(x["EditedById"] == DBNull.Value ? null : x["EditedById"]),

                    EditedTime = Convert.ToDateTime(x["EditedTime"] == DBNull.Value ? null : x["EditedTime"]),

                    //RowId = (byte[])x["RowId"],

                }).ToList();

}

}