Update datetime using .NET and SQL

Question

I have Entity Framework ObjectContext. I need to update column of type datetime.

Here is my code:

ObjectContext.ExecuteStoreCommand(string.Format("update MyTable set DateTimeField='{0}' where Id = {1}",
                                  myEntity.DateTimeField, IdValue));

Why am I getting such exception:

Submit operation failed. The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The Statement has been terminated.

Habib · Accepted Answer · 2013-05-23 11:13:13Z

4

ObjectContext.ExecuteStoreCommand takes SqlParameters so Its better if you use parameterized query like:

ObjectContext.ExecuteStoreCommand(
    "update MyTable set DateTimeField=@pDateTimeField  where Id = @pID", 
      new SqlParameter {ParameterName = "@pDateTimeField", Value =myEntity.DateTimeField  },
      new SqlParameter {ParameterName = "@pID", Value =IdValue });

See: Working with Parameterized Commands - MSDN

Currently your code is not working because it is considering DateTime as string value.

edited May 23, 2013 at 11:13

answered May 23, 2013 at 11:07

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AdaTheDev Over a year ago

+1...just pipped me to it! Assuming myEntity.DateTimeField is a DateTime this should just work

Andrei Over a year ago

My solution worked out for me but doesn't work on staging. I will check in several minutes..

Raimond Kuipers · Accepted Answer · 2013-05-23 11:05:37Z

2

It looks like myEntity.DateTimeField is a string and not a datetime field.

answered May 23, 2013 at 11:05

Raimond Kuipers

1,1461 gold badge10 silver badges20 bronze badges

1 Comment

Jeppe Stig Nielsen Over a year ago

No matter what type it is, after it has come through his code string.Format("some sql '{0}' continue sql", myEntity.DateTimeField), surely it is reduced to a substring of some new string. What that substring looks like depends on what override of ToString() is hit at runtime (virtual method).

Collectives™ on Stack Overflow

Update datetime using .NET and SQL

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related