Tuesday, November 11, 2014

Entity Framework Power Tools

Found this cool entity framework power tool to do reverse engineering for creating code first entity framework data models from an existing database.

Install the Entity Framework Power Tools Beta 4 from here:
https://visualstudiogallery.msdn.microsoft.com/72a60b14-1581-4b9b-89f2-846072eff19d

Once the tool is installed, you should be able to access the entity framework reverse engineer plugin from Visual Studio.

Right click on your solution in Visual Studio and you should see menu option for reverse engineer:
"Entity Framework" -> "Reverse Engineer Code First"

Create a class library for your data layer and click "Reverse Engineer Code First" menu option. Folowwing the instructions to create entity framework data models for an existing database.


Monday, November 3, 2014

Memory gates checking failed because the free memory is less than 5% of total memory

I got this exception when running a service on my localhost:

"Memory gates checking failed because the free memory (180146176 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element."

 I checked memory usage in task manager and the free memory was indeed less than 5%.

Easy fix for this issue is to set "minFreeMemoryPercentageToActivateService" value in "serviceHostingEnvironment" configuration to 0:

<system.serviceModel>
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" minFreeMemoryPercentageToActivateService="0"/>
</system.serviceModel>