[C#] MSSQL Delete

[C#] MSSQL Delete

 

mssql 프로시저 Delete 사용법입니다.

public async Task<bool> DeleteContents(AdvertiserModel model)
{
    try
    {
        using (SqlConnection con = new SqlConnection(Startup.DBConnectionString))
        {
            SqlCommand cmd = new SqlCommand("Delete_AdvertiserInfo", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(DBCommon.MakeParam("@ID", model.ID));
            cmd.Parameters.Add(DBCommon.MakeParam("@UserID", model.UserID));
            con.Open();
            SqlDataReader rdr = await cmd.ExecuteReaderAsync();
 
            if (rdr != null)
            {
                rdr.Close();
            }
            con.Close();
        }
        return true;
    }
    catch (Exception e)
    {
        Debug.WriteLine(e.Message);
        return false;
    }
}