C# (CSharp) SqlDataAccess.ExecuteInlineSqlQuery Examples

Example #1

File: EmployeeOperation.cs Project: lalitslv94/Test

        public void Delete(string id)
        {
            var DelQuery = "DELETE FROM Employee WHERE Id=@id ";

            SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql());

            d.Connection.Open();
            var cmd = d.Command(DelQuery);

            AddObjectParameter(d, cmd, "Id", Convert.ToInt32(id));

            int count = d.ExecuteInlineSqlQuery(cmd);
        }