Metadata-only EFContextProvider about breeze.server.net HOT 5 CLOSED

I've noticed that EF connects to the database to when we ask it for metadata. I assume it's to check for schema updates. I don't know how to turn that off.

from breeze.server.net.

I figured it would be an EF problem. Just putting this out there, more for documentation purposes.

This is the dummy connection string I'm using. The call to Metadata with it takes about 1.6 seconds. Again, if you do this in a static, or do it once and then just use the results in a static file, that solves the problem in production.

Data Source=(LocalDb)\v11.0;Initial Catalog=dummy;Integrated Security=True;Connection Timeout=1

from breeze.server.net.

Did you set the DB Initializer to null as in the example? Without that, EF will try to create the database.

Database.SetInitializer<NorthwindDtoContext>(null)

from breeze.server.net.

I did. It still hung for about 15 seconds. Using the dummy connection string cut it down to under 2 seconds.

from breeze.server.net.

I am going to close it because I don't really think this is a problem with Breeze itself.

I would suggest that, whenever you have time, a note in the documentation that describes this way of doing things can incur a heavy delay. Either don't do it at all in production, or do it once and hold the metadata in a static and return it in the Metadata method.

from breeze.server.net.