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;
}
