How can i set sql date time with entity framework c#.net

Question

I am very new to entity framework. Nice concept and fast as well. Working in c#.net right now. I have stucked here where datetime comes in picture.

I mean....

lets assume i have user table in DB where CreatedDate fields is there in with datetime datatype in sql db.

My entity framework works like this... when i need to add object to db, i simply pass objUser.createdDate = DateTime.now.

How ever I want to change the concept for some requirement changes.

I need to store sql server DateTime() for createdDate field in table.

How can i do that???

any idea...please help. follwoing is a just sample code of my project.

      objCustomer.RegisterDate = DateTime.Now;
            objCustRepository.AddCustomer(objCustomer);

I want to remove this DateTime.Now line and maintain through sql....

Adi · Accepted Answer · 2012-08-29 09:59:31Z

3

if you can store the value from stored procedure instead of your business logic then you can try it by following.

to store SQL Datetime value then you can also use GETDATE() function in SQL.

or

you can define RegisterDate default value = GETDATE()

Adi

5,1796 gold badges35 silver badges48 bronze badges

answered Aug 29, 2012 at 9:53

Nitin Vijay

1,42212 silver badges29 bronze badges

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

1 Comment

You are right, actaully we can default value works. what if i have set that and supply the date from code behind? will take the default value??

ctrlplusb · Accepted Answer · 2012-08-29 10:09:03Z

0

It sounds like you are trying to target the specific timezone associated with your sql server, if I am not mistaken?

If so why not use DateTimeOffset.Now via your c# when setting the date.

A DateTimeOffset represents a specific point in time, so you can use it to convert to any timezone representation you may need on your UI.

Be aware though that it is only supported on SQL Server 2008 and greater, if I remember correctly. :)

answered Aug 29, 2012 at 10:09

ctrlplusb

13.2k7 gold badges58 silver badges57 bronze badges