Make sure you have ...VS2008 sp1 (http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en...).
I had .Net Framework 3.5 SP1 installed but not the VS2008 SP1.
...at least that is what I was doing wrong.
I just ran into this same problem. Visual Studio C# Express 2010 SP1 only offers me Microsoft SQL Server Compact 3.5 and Microsoft SQL Server Database File when creating or updating ADO.NET Entity Data Model (*.edmx) files....However my copy of Microsoft Visual Web Developer 2010 Express SP1 is allowing me to add and update ADO.NET Entity Data Mode...
You could use the ...Entity Framework Profiler... to check what SQL is being generated. This tool has a 30 day free trial. It also claims that it can do "Analysis and detection of common pitfalls when using Entity Framework". ...There is also ...this... article on EF tuning...Edit...Based on your edits EF is not the way to go. You need to do a bulk...
Ideally you should not store documents in the database, instead store the ...path to the document... in the database, which then points to the physical document on the web server itself (or some other storage, CDN, etc)....However, if you must store it in SQL Server (and seeing as though your on SQL 2008),
you should be using ...FILESTREAM.......An...
Open the install media for VS2010 and browse to ":\WCU\EFTools".
Her you will find two files: ...ADONETEntityFrameworkTools_enu.msi...ADONETEntityFrameworkTools_enu.cab...Copy those files to a folder on your PC....Create a log file in the folder - for instance with the name "Log.txt"...Open a cmd prompt (possibly run the cmd prompt as administrator...
In fact Entity Framework 5 components that are shipped with .NET Framework 4.5 do support spatial types. Take a look at this ...walkthrough.......EDIT... With EF6 you can use spatial types on both .NET Framework 4 and .NET Framework 4.5
Go to Web config, search for ... <entity framework>
...Add this ...<contexts>
<context type="UniversityApp.Models.ProfDb , UniversityApp">
<databaseInitializer type="Your SEED , UniversityApp" />
The fix is to modify your EDMX file, using the XML editor, and change the value of ProviderManifestToken from 2012 to 2008. I found that on line 7 in my EDMX file. After saving that change, the paging SQL will be generated using the â€œoldâ€, SQL Server 2008 compatible syntax.