UserModel.cs

public class UserRepository : IUserRepository
{
    public List<User> SelectUser()
    {
        // Select
        List<User> ret;
        using (var db = new SqlConnection(connstring))
        {
            const string sql = @"SELECT Id, Name, Surname, Email, Phone, LastLogon, CreatedOn, ActivationCode, Login, Password, Token, LoginToken, CPF, Birth, ProfileImage, DeviceToken FROM [User]";

            ret = db.Query<User>(sql, commandType: CommandType.Text).ToList();
        }
        return ret;
    }
    public void InsertUser(User user)
    {
        // Insert
        using (var db = new SqlConnection(connstring))
        {
            const string sql = @"INSERT INTO [User] (Name, Surname, Email, Phone, LastLogon, CreatedOn, ActivationCode, Login, Password, Token, LoginToken, CPF, Birth, ProfileImage, DeviceToken) VALUES (@Name, @Surname, @Email, @Phone, @LastLogon, @CreatedOn, @ActivationCode, @Login, @Password, @Token, @LoginToken, @CPF, @Birth, @ProfileImage, @DeviceToken)";

            db.Execute(sql, new { Name = user.Name, Surname = user.Surname, Email = user.Email, Phone = user.Phone, LastLogon = user.LastLogon, CreatedOn = user.CreatedOn, ActivationCode = user.ActivationCode, Login = user.Login, Password = user.Password, Token = user.Token, LoginToken = user.LoginToken, CPF = user.CPF, Birth = user.Birth, ProfileImage = user.ProfileImage, DeviceToken = user.DeviceToken }, commandType: CommandType.Text);
        }
    }
    public void UpdateUser(User user)
    {
        // Update
        using (var db = new SqlConnection(connstring))
        {
            const string sql = @"UPDATE [User] SET Name = @Name, Surname = @Surname, Email = @Email, Phone = @Phone, LastLogon = @LastLogon, CreatedOn = @CreatedOn, ActivationCode = @ActivationCode, Login = @Login, Password = @Password, Token = @Token, LoginToken = @LoginToken, CPF = @CPF, Birth = @Birth, ProfileImage = @ProfileImage, DeviceToken = @DeviceToken WHERE Id = @Id";

            db.Execute(sql, new { Id = user.Id, Name = user.Name, Surname = user.Surname, Email = user.Email, Phone = user.Phone, LastLogon = user.LastLogon, CreatedOn = user.CreatedOn, ActivationCode = user.ActivationCode, Login = user.Login, Password = user.Password, Token = user.Token, LoginToken = user.LoginToken, CPF = user.CPF, Birth = user.Birth, ProfileImage = user.ProfileImage, DeviceToken = user.DeviceToken }, commandType: CommandType.Text);
        }
    }
    public void DeleteUser(User user)
    {
        // Delete
        using (var db = new SqlConnection(connstring))
        {
            const string sql = @"DELETE FROM [User] WHERE Id = @Id";

            db.Execute(sql, new { user.Id }, commandType: CommandType.Text);
        }
    }
}
public interface IUserRepository
{
    List<User> SelectUser();
    void InsertUser(User user);
    void UpdateUser(User user);
    void DeleteUser(User user);
}