public void Update(Dersler less) { using (IDbConnection dbConnection = Connection) { string sQuery = @"UPDATE Lessons SET Class=@Class,LessonName=@LessonName"; dbConnection.Open(); dbConnection.Execute(sQuery, less); } }
public void Add(Dersler less) { using (IDbConnection dbConnection = Connection) { string sQuery = @"INSERT INTO Lessons (FirstName,LastName,Number) VALUES(@FirstName,@LastName,@Number)"; dbConnection.Open(); dbConnection.Execute(sQuery, less); } }