c# - Cannot generate sql in entity framework for oracle database -

-

i trying generate oracle sql entity framework model.

i can generate sqlserver sql fine, error occurs oracle generation.

i've installed oracle developer tools vs fine.
have selected "generate oracle via t4 (tpt).xaml (vs)" database generation workflow, , "ssdltooracle.tt (vs)" ddl generation template.

when attempt generate sql right click menu, following error repeated on , on again:

the ssdl generated activity called 'csdltossdlandmslactivity' not valid , has following errors:
default value (false) not compatible facets specified decimal. value must decimal number scale less or equal 38 , precision less or equal 38.
... [snip]

my model not contain decimals.
tried setting default value of int32's , double's other (none), did not fix it.

can me resolve issue?

can add xml definition project's app/web.config file (inside of "configuration" section), , try again.

<oracle.dataaccess.client>   <settings>     <add name="bool" value="edmmapping number(1,0)" />     <add name="byte" value="edmmapping number(3,0)" />     <add name="int16" value="edmmapping number(5,0)" />     <add name="int32" value="edmmapping number(10,0)" />     <add name="int64" value="edmmapping number(19,0)" />     <add name="int16" value="edmmapping number(38,0)" />     <add name="int32" value="edmmapping number(38,0)" />     <add name="int64" value="edmmapping number(38,0)" />   </settings> </oracle.dataaccess.client>

Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more