Entity Framework 6 - Knowledge Base (KB)

In Linq to Entities / Entity SQL with type conversion, choose Max.

I'm trying to create some CRUD functionality for a legacy database and using the Entity Framework as an ORM tool. One table, 'Sites', has a Guid type 'Id' column which is never seen by the users and an integer type 'SiteId' which the users use to identitf...

LINQ to Entity Framework using a MySQL adapter to convert String to Long

I have a table with a column of type ...varchar... where the majority of rows have numerical looking values, that is, each string contains nothing but the digits 0 through 9....+------+ | n | +------+ | 123 | | 234 | | BLAH | -- This row is an excep...

How to use Date Only as data type in Entity Framework

When I use Entity Framework as an ORM, for each ...Date... data type in my SQL Server DB it creates a ...DateTime... data type ...y... in my MVC project. ...I mean, for each table in my DB, in my MVC project is auto-generated the code for this class using...

conversion of a datetime2 data type to a smalldatetime EF6 MVC5

I am using MVC5 with EF6 code first. I have a table with a Date(Datum) column in both tabels(Kommunication and Itemannounce) with smalldatetime type and when I try to set the date with System.DateTime.Now in the column I get the following error:...The con...