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