public DeleteByMonthAndYear ( int month, int year ) : void | ||
month | int | |
year | int | |
return | void |
public void DeleteByMonthAndYear(int month, int year)
{
using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
{
connection.Open();
string command = "DELETE GameStatistics FROM GameStatistics gs INNER JOIN Game g ON g.Id = gs.GameId WHERE (DATEPART (month, g.[Date])) = @Month AND (DATEPART (year, g.[Date])) = @Year";
connection.Execute(command, new { Month = month, Year = year });
}
}