locked
How to get the same data using EntityFramework RRS feed

  • Question

  • User-14642827 posted

    How would get the below data using entity framework?

    public int InsertPersonActivityLog(int logId, string edi, string personFormalName, DateTime activityDateTime, string activityTypeDescriptor, string additionalDetails, string reasonMessage, string notes)
            {
                StringBuilder errorMessages = new StringBuilder();
                try
                {
                    // Get the connection string from the appsettings.json.
                    conn.ConnectionString = myConn.DefaultConnectionString(configuration);                                                                                          // Open the connection.
                    conn.Open();
                    cmd.Connection = conn;
    
                    // Set the command type of the command object.
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
    
                    // Assign values as "parameters to avoid 'SQL Injections.'"
                    cmd.Parameters.AddWithValue("@edi", edi);
                    cmd.Parameters.AddWithValue("@formalName", personFormalName);
                    cmd.Parameters.AddWithValue("@date", activityDateTime);
                    cmd.Parameters.AddWithValue("@descriptor", activityTypeDescriptor);
                    cmd.Parameters.AddWithValue("@details", additionalDetails);
                    cmd.Parameters.AddWithValue("@reason", reasonMessage);
                    cmd.Parameters.AddWithValue("@notes", notes);
    
                    return cmd.ExecuteNonQuery();
                }
                catch(SqlException ex)
                {
                    for (int i = 0; i < ex.Errors.Count; i++)
                    {
                        errorMessages.Append("Index #" + i + "\n" +
                            "Message: " + ex.Errors[i].Message + "\n" +
                            "LineNumber: " + ex.Errors[i].LineNumber + "\n" +
                            "Source: " + ex.Errors[i].Source + "\n" +
                            "Procedure: " + ex.Errors[i].Procedure + "\n");
                    }
                    Console.WriteLine(errorMessages.ToString());
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                }
                return 0;
            }

    Wednesday, January 31, 2018 7:24 PM

All replies