public static void VerifyQuery(DbExpression query, MetadataWorkspace workspace, string expectedSql)
{
var providerServices =
(DbProviderServices)((IServiceProvider)EntityProviderFactory.Instance).GetService(typeof(DbProviderServices));
var connection = new EntityConnection(workspace, new SqlConnection());
var commandTree = workspace.CreateQueryCommandTree(query);
var entityCommand = (EntityCommand)providerServices.CreateCommandDefinition(commandTree).CreateCommand();
entityCommand.Connection = connection;
Assert.Equal(StripFormatting(expectedSql), StripFormatting(entityCommand.ToTraceString()));
}
