public void Execute(ICommandQuery commandQuery) { var sql = $@"Insert into Players (FirstName, LastName, Email, Phone, RatingId, TeamId) values (@FirstName, @LastName, @Email, @Phone, @RatingId, @TeamId)"; commandQuery.Execute(sql, _players); }
Player IQuery <Player> .Execute(ICommandQuery commandQuery) { var sql = @"Insert into Players (FirstName, LastName, Email, Phone, RatingId, TeamId) values (@FirstName, @LastName, @Email, @Phone, @RatingId, @TeamId); select cast(scope_identity() as int)"; _player.Id = commandQuery.Query <int>(sql, _player).First(); return(_player); }
Team IQuery <Team> .Execute(ICommandQuery commandQuery) { var sql = @"Insert into Teams (Gender, Name, RatingId) values (@Gender, @Name, @RatingId); select cast(scope_identity() as int)"; _team.Id = commandQuery.Query <int>(sql, _team).First(); return(_team); }
public BookRepository(IEnumerable <IDbConnectionFactory> connectionFactory, ICommandQuery commandQuery, string connectionName = "") { _connectionFactory = string.IsNullOrEmpty(connectionName) ? connectionFactory.FirstOrDefault() : connectionFactory.FirstOrDefault(c => c.ConnectionName == connectionName); if (_connectionFactory == null) { throw new ArgumentNullException(nameof(connectionFactory)); } _commandQuery = commandQuery; }
public IEnumerable <Rating> Execute(ICommandQuery commandQuery) { return(commandQuery.Query <Rating>("select * from Ratings")); }
public Database(ICommandQuery commandQuery) { _commandQuery = commandQuery; }
public ConsoleLogger(ICommandQuery cmd, IDateTime dateTime) { command = cmd; currDateTime = dateTime; }