Entity Framework 6 - Knowledge Base (KB)

Select Max in Linq to Entities / Entity SQL with type conversion

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...

Converting String to Long ...in LINQ to Entity Framework using a MySQL adaptor

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...