How to use DateTime.AddDays(x) in Entity Framework

Adding existing entities to a collection on a newly built object using the entity framework

I am using the Entity framework to create a new order. The order contains a collection of contacts, a many to many relationship. I want to add a reference to an existing contact on the order on creation of the order. Both Order and Contact a Entity Objects.... Order order = new Order(); //set details on order Contact contact = new Contact();...

How can I use entity framework to query the database server for the current datetime?

Is there a reason you just can't push it down to your database? If you include DateTime.Now in your entity query, it will push it down (getdate) to the database....Example linq to entities... var dQuery = dbContext.CreateQuery<DateTime>("CurrentDateTime() "); DateTime dbDate = dQuery.AsEnumerable().First(); ...SQL Generated .....SELECT GetDate() ...

Using linq-to-entities to convert a string to a datetime has a significant problem.

Convert.ToDatetime... is supported by Linq2SQL. The only supported method of Linq to entities are these: ...http://msdn.microsoft.com/en-us/library/bb738681.aspx...about your problem ... try to convert ...startdate... and ...enddate... in string and compare the string value in linq expression.

DateTime in entity Framework && DateTime in sql format returning different results

Guys i have a big problem in entity framework and DateTime. Here the problem:...First with entity:...When the user submit the form them those values are being create for a condicional query depending on which parameter the user type. Example:...var query = from user in UserTable select user; if(Request.Form["Category"]) { ...

why i can't save the current DateTime.Now using Entity Framework

Do not switch the ...Optmistic Concurrency Updates... off you will hide the problem and not fix it. do the following:...using (var db = new MyEntities()) { using (var transaction = new TransactionScope()) { var newGroup = new Groups { GroupDate = DateTime.Now, GroupName = "someName" }; ...

How to implement a DateTime entity property to set always DateTime.Now

You could add a constructor to your class and then initialize there your property....public class News { // properties goes here public News() { Date=DateTime.Now; } } ...A far better constructor would be the following...public News(int newsId, string title, string content) { NewsId=newsId; Title=title; Content=con...

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...

Nullable DateTime property in Entity Framework 6 thows exception on save when value is null

I have defined a Nullable ...DateTime...property in one of my classes:...public DateTime? ControlDate { get; set; } ...When using EF 6 CodeFirst to generate the database (SQL Server 2008) from my model I get:...The problem is that when I save my instance with ...ControlDate=null... I get this exception:...conversion of a datetime2 data type to a da...

Entity Framework 6 related entity where datetime clause doesn't translate to SQL

"EF makes some very expensive queries" mmm you have control of how you would like to use the framework with its limitation*, if you know something is bad but still do it that way its not EF fault....You could do it exactly the way you have....i.e. if you did this with raw sql how would you do it....Then simply do the same in EF....var channel = co...

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

It doesn't matter if you use Add in a foreach or AddRange, problem lies in SaveChanges method, as it stores changes in observed entities one by one I think. There are libraries out there that allows for real bulk insert of entities using under the hood mechanism of ...SqlBulkCopy...Link to EF Core library: ...EFCore.BulkExtensions...EDIT: For EF6 I...