c# - Oracle Entity Framework provider doesn't store DateTime.Now with milliseconds -


i have exact same question guy here.

why can't save current datetime.now using entity framework

but using sql server, , using oracle. (my application must work both)

his problem precision wasn't set correctly @ db level.

i've noticed if manually edit milliseconds in oracle database, ef can pull out correct timestamp milliseconds. when create entity datetime property "datetime.now" gets truncated.

the datecolumn1 attribute of oracle type timestamp

i logged insert statement

insert "schemaname"."tablename"("datecolumn1") values (:p0) --:p0:'5/14/2015 4:07:27 pm' (type = date)

the crazy thing works in sql server.

aha! awesome colleague had idea , worked!

in our ef code tried putting

protected override void onmodelcreating(dbmodelbuilder modelbuilder) {     modelbuilder.entity<entityclass>().property(p => p.timestamp).hasprecision(6); }

and datetime.now milliseconds got stored database

update - it's worth mentioning how got in predicament

building database model first in "test" application

  1. my app has work both sql server , oracle. so...
  2. i started designing database in edmx diagram
  3. once diagram done, generated ddl sql server.

  4. for reason oracle ef provider couldn't generate ddl proceeded manually make changes sql server ddl correct syntactically

    1st problem - oracle ddl using date instead of timestamp. make sure use timestamp!!! datetime in oracle doesn't store milliseconds.

using code first database actual solution

  1. i wanted app use code first approach (just preference. think it's easier maintain)
  2. so connected sql server database , generated of classes schema.
  3. i got of unit tests passing , decided test oracle database
  4. even after changing date timestamp, still having problems milliseconds going in.
  5. i generated code first model in test visual studio solution timestamp(6) type in oracle, except when looked @ onmodelcreating code, did not generate hasprecision(6) nor there decorators on property in generated c# poco class.
  6. i noticed if have hasprecision(6) code in onmodelcreating, code firstcreatedatabase() make oracle timestamp(6). if don't, oracle ef provider use date

i think if model first approach can set precision values in edmx diagram, i've heard it's bad practice.


Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i...
Read more