public static SqlExpressCommand Create(string sqlStatement,Query query)
 {
     SqlExpressCommand command = new SqlExpressCommand();
     command.AppendStatement(sqlStatement);
     command.TranslateQuery(query);
     return command;
 }
 protected override IDataReader ExecuteReader(SqlExpressCommand command)
 {
     if(command.DbParameters==null)
     {
         return SqlHelper.ExecuteReader(ConnectionString, command.CommandType, command.StatementString);
     }
     SqlParameter[] sqlParameters = command.DbParameters.Cast<SqlParameter>().ToArray();
     return SqlHelper.ExecuteReader(ConnectionString, command.CommandType, command.StatementString,
                                    sqlParameters);
 }
 public SqlServerQueryTranslator(SqlExpressCommand sqlCommand, Query query)
 {
     _sqlCommand = sqlCommand;
     _query = query;
 }
 public static IQueryTranslator Create(SqlExpressCommand command,Query query)
 {
     return new SqlServerQueryTranslator(command,query);
 }