Esempi in C# (CSharp) per Ado.Net SQLHelper

Esempio n. 1

File: CourseService.cs Progetto: existpan/ProjectUITeach

        public int Delete(Course course)
        {
            string sql = $"delete from Course where CourseId={course.CourseId}";

            return(SQLHelper.ExecuteNonQuery(sql));
        }

Esempio n. 2

File: CourseService.cs Progetto: existpan/ProjectUITeach

        public int Update(Course course)
        {
            string sql = $"update Course set CourseContent='{course.CourseContent}' where CourseId={course.CourseId}";

            return(SQLHelper.ExecuteNonQuery(sql));
        }