SQL Server to Entity Framework data type mapping

Entity Framework: LINQ to Entities only supports casting Entity Data Model primitive types

I wrote a method to allow for an Expression to be passed in for the orderby clause, but I ran into this problem....Unable to cast the type 'System.DateTime' to type 'System.IComparable'. LINQ to Entities only supports casting Entity Data Model primitive types....Basically the expression is this:...Expression<Func<K, IComparable>> orderBy ..

Data Type for storing document in SQL Server 2008 via Entity Framework

I'm trying to store a document in SQL Server 2008 using the Entity Framework....I believe I have the code for doing this completed. The problem I'm now facing is which Data Type to use in SQL Server and in my entity model....'Image' was my first choice, but this causes an "Invalid mapping" error when I update the model. I see that there's no equiva...

Entity Framework Mapping SQL Server tinyint to Int16

A ...tinyint... should get mapped to a .NET ...byte...; ...Int16... should be the corresponding type for a ...smallint... in SQL.

Entity Framework SQL Exception: The supplied value is not a valid instance of data type float

I got this exact same error. It turns out I was dividing a float by zero. This didn't throw an exception in the code at the time I did the division; when I tried to save this value in the database I got the error....Hope this is useful to some of you reading the question - Thanks John for raising it.

Entity Framework Mapping DateTimeOffset to SQL Server DateTime

No. ...DateTimeOffset... in .NET class will map to ...DateTimeOffset... SQL type. You cannot change this behavior directly because EF doesn't provide simple type conversions / mappings. If you want to store it as ...DateTime... you must hack it....First define Customer class with trick to expose private property to mapping referenced by @cincura.ne...

How to read / write geography data using C#, Entity Framework and SQL Server 2008?

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

Entity Framework 6 with SQL Server 2012 gives System.Data.Entity.Core.ProviderIncompatibleException

Try this. Make sure that the project that your ShoppingCartContext is in, is the start up project or when executing the add-migration command include the parameter -startupprojectname ex. add-migration -startupprojectname yourprojectname

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

You need to install the SQL Server Compact Toolbox on the new dev machine, it installs the DDEX provider for you. (You may have to go to the About screen in the Toolbox and clikc the DDEX install button, then restart VS)

Pass table value type to SQL Server stored procedure via Entity Framework

I created a user-defined table type in SQL Server:...CREATE TYPE dbo.TestType AS TABLE ( ColumnA int, ColumnB nvarchar(500) ) ...And I'm using a stored procedure to insert records into the database:...create procedure [dbo].[sp_Test_CustomType] @testing TestType READONLY as insert into [dbo].[myTable] select ColumnA, ColumnB...

Property type of 'System.Data.Entity.Spatial.DbGeography' which cannot be mapped to a primitive type

We finally figured out what our problem was. I'll post hoping it may help someone else. We were using Entity Data Source with a few of our controls and this is no longer supported with EF 6. ...Here's the corresponding stack overflow Q/A that helped us: ...EntityDataSource and Entity Framework 6