MS SQL Server 2008 DateTime2 support

[ie]

Hey guys,

Currently, the DateTime2 is mapped as a string. Such mapping results to DataStoreException. I found a similar thread. I'm using the build 2010.1.527.2. Is it Q1 2010?

Thank,

Ivan.

[Thomas]

Hello ie,

at the moment, this type is not yet supported. We are currently working on improving type handling, but it won't be available until Q2.

Best regards,
Thomas
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Mika Jacobi]

Hi !
How is it possible to automatically force the mapping into "datetime" rather than "string" in the meanwhile (Q2) ?
(by editing default mapping or a config file somewhere, rather that fetching manually each field with this type to change it)

ThanX

[Thomas]

Hello Mika Jacobi,

that should be possible by specifying
...
<field name="myFieldName">
    <extension key="db-column">
        <extension key="db-type" value="DATE"/>
        <extension key="db-sql-type" value="DATETIME2"/>
    </extension>
</field>
...

We are currently working on making these types supported, and very likely you will not need to specify
the db-type in the future.

All the best,
Thomas
the Telerik team

[Thomas]

Hello Mika Jacobi,

I was a bit quick to hit the send button: These settings have to be made in the app.config file under the respective class element.

Greetings,
Thomas
the Telerik team

[Pål]

Hi.

I tried this manual mapping and the database creates a datetim2 field, but inserting anything before 1753 into SQL server throws an exception. Seems like there is a check before the insert to prevent this.

Am I doing it wrong? Is support for this built in to the latest version?

Thanks

Pål

[Thomas]

Hello Pål,

yes, seems like a bug. However, I've just verified this will work out of the box with the next release, which contains a better framework to deal with such altered types. Thanks for reporting this issue!

Greetings,
Thomas
the Telerik team

[Steve A]

Dear Telerik,

This DateTime2 problem is very serious. Do you have a realistic timeline for the "Next Version"

Thanks

[Alexander]

Hello Steve A,

The Q3 2010 release is scheduled for the middle of November.

Greetings,
Alexander
the Telerik team