public ITableContextCommand GetCommand(LookupTableCommand commandType) { var mongoClient = new MongoClient(_connectionString); var mongoServer = mongoClient.GetServer(); var command = new MongoLookupTableCommand(mongoServer, mongoServer.GetDatabase("ISO"), commandType); switch (commandType) { case LookupTableCommand.SaveLookupTableKey: //command.CommandType = CommandType.Text; break; case LookupTableCommand.GetAllTables: //command.CommandText = "GetAllTableMetadata"; //command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.GetTable: //command.CommandText = "GetTableByChangeId"; //command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.DeleteRow: //command.CommandType = CommandType.Text; break; case LookupTableCommand.DropTable: //command.CommandText = "DropTableByChangeId"; //command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.GetTableByName: //command.CommandText = "Api.GetTables"; //command.CommandType = CommandType.StoredProcedure; break; } return command; }
public ITableContextCommand GetCommand(LookupTableCommand commandType) { var command = new SqlCommand { Connection = new SqlConnection(_connectionString) }; switch (commandType) { case LookupTableCommand.SaveLookupTableKey: command.CommandType = CommandType.Text; break; case LookupTableCommand.GetAllTables: command.CommandText = "GetAllTableMetadata"; command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.GetTable: command.CommandText = "GetTableByChangeId"; command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.DeleteRow: command.CommandType = CommandType.Text; break; case LookupTableCommand.DropTable: command.CommandText = "DropTableByChangeId"; command.CommandType = CommandType.StoredProcedure; break; case LookupTableCommand.GetTableByName: command.CommandText = "Api.GetTables"; command.CommandType = CommandType.StoredProcedure; break; } return new SqlLookupTableCommand(command, commandType); }
public SqlLookupTableCommand(SqlCommand command, LookupTableCommand commandType) { _command = command; _commandType = commandType; }
public MongoLookupTableCommand(MongoServer server, MongoDatabase database, LookupTableCommand commandType) { _server = server; _database = database; _commandType = commandType; }