Comments (7)
As it turns out, the issue is with new CE and the reverse engineering queries.
If you revert to legacy CE, import of the database is going to be snappy.
Just run the following statement in the database before importing:
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION=ON
I will follow up with the QO and EF teams to see what we can do to address this problem.
Thanks,
Jos
From: Jos de Bruijn
Sent: Friday, June 10, 2016 1:22 PM
To: 'Microsoft/sql-server-samples' [email protected]; Microsoft/sql-server-samples [email protected]
Cc: Mention [email protected]
Subject: RE: [Microsoft/sql-server-samples] Not playing well with EF6 Designer (#57)
Thanks for the offer, but no need. I can reproduce on my end.
From: Julie Lerman [mailto:[email protected]]
Sent: Friday, June 10, 2016 11:58 AM
To: Microsoft/sql-server-samples <[email protected]mailto:[email protected]>
Cc: Jos de Bruijn <[email protected]mailto:[email protected]>; Mention <[email protected]mailto:[email protected]>
Subject: Re: [Microsoft/sql-server-samples] Not playing well with EF6 Designer (#57)
@jodebruihttps://github.com/jodebrui happy to show you on skype in prep if you want. Something tells me they are busy busy with EF Core and EF6 Designer may be last thing they are interested in right now...
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://github.com//issues/57#issuecomment-225267244, or mute the threadhttps://github.com/notifications/unsubscribe/AMuA9hM62LBeVr36-NbPSWLvfXBEAjg-ks5qKbO7gaJpZM4IzMHx.
from sql-server-samples.
Thanks for trying out this scenario.
I will work with the EF folks to understand the issue.
From: Julie Lerman [mailto:[email protected]]
Sent: Friday, June 10, 2016 11:09 AM
To: Microsoft/sql-server-samples [email protected]
Subject: [Microsoft/sql-server-samples] Not playing well with EF6 Designer (#57)
Some experiments have seemingly narrowed a problem down to this database. I tried the same with adventureworks in SQL Server 2016 and it's not a problem.
In VS2015 SP2 with latest SSDT tools (june 2016), SQL Server 2016 Developer Edition and SSMS for SQL Server 2016 installed.
Create new class library project.
Add new item: Entity Framework Data Model.
Select connection to World Wide Importers (not DW) on SQL Server 2016 instance.
Select all tables.
Go (which will install EF6 package and reverse engineer itables into classes).
It takes about 3 minutes. It should take about 10 seconds max.
Doing the same with AdventureWorks (not LT) is about 10 seconds.
I did this a number of time and each time it takes a while.
Is there something particular about the database schema or special SS2016 features that might create this problem? I don't normally recommend building a model from an entire database but this also happens if I only select a handful of tables.
It seems specific to the database and will make it hard for people to use when using it to explore EF.
On the other hand, I know how Greg feels about EF so maybe it's intentional. JUST KIDDING! :)
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/57, or mute the threadhttps://github.com/notifications/unsubscribe/AMuA9kzANW4tPidfwom3Mvj3x0UwHyx-ks5qKahGgaJpZM4IzMHx.
from sql-server-samples.
@jodebrui happy to show you on skype in prep if you want. Something tells me they are busy busy with EF Core and EF6 Designer may be last thing they are interested in right now...
from sql-server-samples.
Thanks for the offer, but no need. I can reproduce on my end.
From: Julie Lerman [mailto:[email protected]]
Sent: Friday, June 10, 2016 11:58 AM
To: Microsoft/sql-server-samples [email protected]
Cc: Jos de Bruijn [email protected]; Mention [email protected]
Subject: Re: [Microsoft/sql-server-samples] Not playing well with EF6 Designer (#57)
@jodebruihttps://github.com/jodebrui happy to show you on skype in prep if you want. Something tells me they are busy busy with EF Core and EF6 Designer may be last thing they are interested in right now...
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://github.com//issues/57#issuecomment-225267244, or mute the threadhttps://github.com/notifications/unsubscribe/AMuA9hM62LBeVr36-NbPSWLvfXBEAjg-ks5qKbO7gaJpZM4IzMHx.
from sql-server-samples.
Can we further narrow it down to one or a set of tables? If we can do that, we can start to zero in on what features in WWI are causing SSDT to be inefficient.
From: Julie Lerman [mailto:[email protected]]
Sent: Friday, June 10, 2016 11:09 AM
To: Microsoft/sql-server-samples [email protected]
Subject: [Microsoft/sql-server-samples] Not playing well with EF6 Designer (#57)
Some experiments have seemingly narrowed a problem down to this database. I tried the same with adventureworks in SQL Server 2016 and it's not a problem.
In VS2015 SP2 with latest SSDT tools (june 2016), SQL Server 2016 Developer Edition and SSMS for SQL Server 2016 installed.
Create new class library project.
Add new item: Entity Framework Data Model.
Select connection to World Wide Importers (not DW) on SQL Server 2016 instance.
Select all tables.
Go (which will install EF6 package and reverse engineer itables into classes).
It takes about 3 minutes. It should take about 10 seconds max.
Doing the same with AdventureWorks (not LT) is about 10 seconds.
I did this a number of time and each time it takes a while.
Is there something particular about the database schema or special SS2016 features that might create this problem? I don't normally recommend building a model from an entire database but this also happens if I only select a handful of tables.
It seems specific to the database and will make it hard for people to use when using it to explore EF.
On the other hand, I know how Greg feels about EF so maybe it's intentional. JUST KIDDING! :)
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/57, or mute the threadhttps://github.com/notifications/unsubscribe/ALT5rdLX6M0HlsUnQh-UD4tjWZSkePe2ks5qKahGgaJpZM4IzMHx.
from sql-server-samples.
Updating the following statistics fixes the issue for the Full version of the sample:
update statistics sys.syscolpars
update statistics sys.sysschobjs
Standard version is still being investigated.
from sql-server-samples.
The following stats updates fix the problem for the Standard version of the sample DB:
update statistics sys.syscolpars
update statistics sys.sysschobjs
update statistics sys.syssingleobjrefs
update statistics sys.sysiscols
I updated the database create scripts and uploaded new backups to the release page.
With these updates, reverse engineering in EF6 takes <10 seconds for me.
Thanks again for reporting this issue.
Let us know if there are any further concerns or you encounter any other issues.
Thanks,
Jos
from sql-server-samples.
Related Issues (20)
- Probe IndexStatistics failed to obtain data: Execution Timeout
- Calling Http endpoints in T-SQL using CURL extension - Content Type. HOT 1
- Sql
- Sebas
- Please update Security Permissions Posters and Post to Newer Blog Site
- create database SQL HOT 2
- .
- Incomplete samples/databases/wide-world-importers/wwi-ssdt/wwi-ssdt/PostDeploymentScripts/pds150-ins-app-cities-h.sql script
- Create Database
- install SQL server connect Database engine HOT 1
- Sql
- SqlEngineConfigAction_install_confignonrc_Cpu64 on Windows 11 HOT 1
- Just to mention ....
- Invoke-SqlAssessment - IndexFragmentation rule doesn't take partitions into consideration HOT 2
- Unpicked sales in WorldWideImporters database causes purchases to increase indefinitely?
- Importing AdventureWorks script does not work on fresh install of SSMS 19 HOT 1
- Data generation fails due to invalid records in ColdRoomTemperatures HOT 1
- Azure SQL Managed Instance sample script for Attach-vpn-gateway fails as VPN SKU is deprecated
- Huiu
- Unable to install on Parallels Desktop
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-server-samples.