blocks|key|1048838|text|将DateCreated类型更改为datetime2可能会解决此问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1048839|日期时间2007-05-08+12:35:29.123|1048840|datetime2+2007-05-08+12:35:2912345|1048841|参考：http://technet.microsoft.com/en-us/library/bb677335.aspx67|offset|length|1048842|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/bb677335.aspx67^0|0|0|0|3|1M|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

Changing type of DateCreated to datetime2 might solve the problem.

datetime 2007-05-08 12:35:29.123

datetime2 2007-05-08 12:35:29. 12345

Ref: <a href="http://technet.microsoft.com/en-us/library/bb677335.aspx67" rel="nofollow noreferrer">http://technet.microsoft.com/en-us/library/bb677335.aspx67</a>

blocks|key|1263546|text|您必须手动编辑edmx+xml，并将SSDL+StoreGeneratedPattern属性设置为identity或computed。但是，每当您通过设计器更新您的edmx时，您所做的更改将被覆盖。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1263547|这是一个已知的问题。有关更多详细信息，请参阅以下链接：|1263548|Microsoft+Connect+Ticket|offset|length|1263549|Using+a+GUID+as+an+EntityKey+in+Entity+Framework+4|1263550|entityMap|0|LINK|mutability|MUTABLE|url|https://connect.microsoft.com/VisualStudio/feedback/details/505178/storegeneratedpattern-property-in-ado-net-entity-model-designer-sets-cdsl-annotation-but-not-ssdl-attribute|1|http://leedumond.com/blog/using-a-guid-as-an-entitykey-in-entity-framework-4/^0|0|0|0|O|0|0|0|1E|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$F|10|G|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

You have to manually edit the edmx xml and set your SSDL StoreGeneratedPattern attributes to identity or computed. But whenever you update your edmx via the designer your changes will get overwritten.

This is a known issue. Please see the following links for more details:

<a href="https://connect.microsoft.com/VisualStudio/feedback/details/505178/storegeneratedpattern-property-in-ado-net-entity-model-designer-sets-cdsl-annotation-but-not-ssdl-attribute" rel="noreferrer">Microsoft Connect Ticket</a>

<a href="http://leedumond.com/blog/using-a-guid-as-an-entitykey-in-entity-framework-4/" rel="noreferrer">Using a GUID as an EntityKey in Entity Framework 4</a>

blocks|key|1263579|text|以下是一种解决方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1263580|1)将该列更改为datetime2，如其他地方所述。这修复了转换错误。|1263581|2)添加触发器，将DateCreated设置为getdate()；|1263582|CREATE+TRIGGER+[TR_AS_ChangeTime]+ON+[AS_ApplicationSession]+
++AFTER+INSERT,UPDATE+AS
BEGIN

++SET+NOCOUNT+ON;
++UPDATE+AS_ApplicationSession+
++SET+AS_ChangeTime+=+getdate()+
++WHERE+AS_Id+IN(SELECT+AS_ID+FROM+INSERTED)

END|code-block|syntax|javascript|1263583|3)如有必要，设置|1263584|p.DateCreated+=+DateTime.MinValue;|1263585|只是为了初始化它。|1263586|4)如果您需要数据库中的DateCreated，请添加|1263587|context.Refresh(System.Data.Objects.RefreshMode.StoreWins,+p);|1263588|紧接着|1263589|context.SaveChanges();|1263590|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|15|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|H|7|18|8|@]|9|@]|A|$I|J]]|$1|U|3|V|5|6|7|19|8|@]|9|@]|A|$]]|$1|W|3|X|5|H|7|1A|8|@]|9|@]|A|$I|J]]|$1|Y|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Z|$]]

Here is a working workaround:

1) Change the column to datetime2 as mentioned elsewhere. This fixes the conversion error.

2) Add a trigger that sets DateCreated to getdate();

<pre><code>CREATE TRIGGER [TR_AS_ChangeTime] ON [AS_ApplicationSession] 
 AFTER INSERT,UPDATE AS
BEGIN

 SET NOCOUNT ON;
 UPDATE AS_ApplicationSession 
 SET AS_ChangeTime = getdate() 
 WHERE AS_Id IN(SELECT AS_ID FROM INSERTED)

END
</code></pre>

3) If neccessary, set 

<pre><code>p.DateCreated = DateTime.MinValue;
</code></pre>

just to initialize it.

4) If you need the DateCreated from the database, add

<pre><code>context.Refresh(System.Data.Objects.RefreshMode.StoreWins, p);
</code></pre>

just after

<pre><code>context.SaveChanges();
</code></pre>

blocks|key|1263627|text|我也有同样的问题！对我来说，它是这样工作的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1263628|数据库MS+SQL+Server+express：|1263629|[RowTime]++[datetime2](7)++NOT+NULL

ALTER+TABLE+[dbo].[Table_1]+ADD++CONSTRAINT+[DF_Table_1_RowTime]++DEFAULT+(getdate())+FOR+[RowTime]
GO|code-block|syntax|javascript|1263630|然后将表从数据库导入到我的实体模型中。实体将不会实现默认值！因此，您必须将列的StoreGeneratedPattern设置为Computed。那么实体将不再有任何默认值。|1263631|以下各项的组合：|1263632|datetime2,
NOT+NULL,+
StoreGeneratedPattern=Computed|1263633|对我很管用！|1263634|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I had the same problem! For me it works like this:

Database MS SQL Server express:

<pre><code>[RowTime] [datetime2](7) NOT NULL

ALTER TABLE [dbo].[Table_1] ADD CONSTRAINT [DF_Table_1_RowTime] DEFAULT (getdate()) FOR [RowTime]
GO
</code></pre>

Then I import the table from database to my Entities model.
Entities will not realise the default value!
So, you have to set the StoreGeneratedPattern of the column to Computed.
Then Entities will not put there any default value any more.

Combination of:

<pre><code>datetime2,
NOT NULL, 
StoreGeneratedPattern=Computed
</code></pre>

Works for me!

I have a column like this in 1 of my database tables

<pre><code>DateCreated, datetime, default(GetDate()), not null
</code></pre>

I am trying to use the Entity Framework to do an insert on this table like this...

<pre><code> PlaygroundEntities context = new PlaygroundEntities();

 Person p = new Person
 {
 Status = PersonStatus.Alive,
 BirthDate = new DateTime(1982,3,18),
 Name = "Joe Smith"
 };

 context.AddToPeople(p);
 context.SaveChanges();
</code></pre>

When i run this code i get the following error

<pre><code>The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.\r\nThe statement has been terminated.
</code></pre>

So i tried setting the StoreGeneratedPattern to computed... same thing, then identity... same thing. Any ideas?

How to manage GetDate() with Entity Framework

SQL Server

数据库

我的一个数据库表中有一列如下所示DateCreated, datetime, default(GetDate()), not null我正在尝试使用实体框架在此表上执行插入操作，如下所示……        PlaygroundEntities context = new PlaygroundEntities();   ...

问如何使用实体框架管理GetDate()
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用实体框架管理GetDate()EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用实体框架管理GetDate()
EN