Code Monkey home page Code Monkey logo

Comments (7)

jodebrui avatar jodebrui commented on June 16, 2024 1

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.

jodebrui avatar jodebrui commented on June 16, 2024

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.

julielerman avatar julielerman commented on June 16, 2024

@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.

jodebrui avatar jodebrui commented on June 16, 2024

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.

Kevin-Farlee avatar Kevin-Farlee commented on June 16, 2024

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.

jodebrui avatar jodebrui commented on June 16, 2024

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.

jodebrui avatar jodebrui commented on June 16, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.