Step 4 : From SOAP to WCF-RESTful-DELETE

SOAP :



[WebMethod(Description = "Method to Delete User")]
public bool DeleteUser(string username)
{
   bool returnBool = false;
   SqlConnection dbConn = new SqlConnection(connStr);
   string sqlStr = "DELETE FROM users where username = '" + username +"';";
   SqlCommand dbCommand = new SqlCommand(sqlStr,dbConn);
try
{
   dbConn.Open();
   if (dbCommand.ExecuteNonQuery()!=0)
   {
      returnBool=true;
   }
}
catch
{
   returnBool=false;
}
   dbConn.Close();
   return returnBool;
}




WCF REST :


        [OperationContract]
        [WebInvoke(Method = "DELETE",
            ResponseFormat = WebMessageFormat.Xml,
            RequestFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.Bare,
            UriTemplate = "usrdel/{user}")]
        bool DeletePerson(string user);

        public bool DeletePerson(string user)

        {

            bool returnBool = false;

            SqlConnection dbConn = new SqlConnection(connStr);

            string sqlStr = "DELETE FROM users where username = '" + user + "';";

            SqlCommand dbCommand = new SqlCommand(sqlStr, dbConn);

            try

            {

                dbConn.Open();

                if (dbCommand.ExecuteNonQuery() != 0)

                {

                    returnBool = true;

                }

            }

            catch

            {

                returnBool = false;

            }

            dbConn.Close();

            return returnBool;

        }

Implement CRUD operations using
RESTful WCF Service and javascript

REST in WCF – Part XI (Tunneling PUT through POST)