Page 1 of 1

Code-First Support

Posted: Wed 21 Jul 2010 23:15
by gsogol
Does anyone know if code-first is supported, meaning no modeling via Visual Studio designer but doing modeling via the new CTPs? http://blogs.msdn.com/b/adonet/archive/ ... ement.aspx

I'm assuming this devart provides a driver but not sure how it's actually tied together.

Posted: Fri 23 Jul 2010 10:53
by AndreyR
We are in the process of testing the new Entity Framework CTP 4.
I will post here about the test results.

Posted: Wed 28 Jul 2010 16:59
by gsogol
Any updates on the code-first EF CTP4 with dotConnect for Oracle?

Posted: Thu 29 Jul 2010 14:50
by AndreyR
I will post here about the results of our investigation as soon as possible.

Posted: Fri 06 Aug 2010 21:26
by gsogol
I'm assuming you're still testing but just wanted to know how it's looking so far and if you have an approximate date? Just have a project against Oracle and wanted to know if at least the read-only stuff works with code-first.

Posted: Thu 12 Aug 2010 22:18
by gsogol
I'm doing some testing myself and following --> http://weblogs.asp.net/scottgu/archive/ ... abase.aspx


Can someone at least point me in the right direction? Which DevArt dlls should I reference? And if I follow something similar as the link above, how will it know to use DevArt's EF for Oracle and not Microsoft's. Please help out and I'll try this out myself and post back the results.

I have a really important and visible project and I need this bad.

Posted: Fri 13 Aug 2010 19:35
by gsogol
Did everything per ScottGu's article using Devart's provider for Oracle and getting "DatabaseExists is not supported by the provider.". Guessing from the error the provider does not support this method. Any way to tell the framework may be not to use the method, bypass it?

Posted: Fri 13 Aug 2010 20:24
by gsogol
Seems like I'm talking to myself here, but setting Database.SetInitializer to something that does nothing now bypasses this particular issue and now I'm getting table or view does not exist. Tried using the schema in .ToTable("Schema.View") and still the same. privileges seem to be fine.

Posted: Fri 13 Aug 2010 21:05
by gsogol
In case it helps anyone. I got it working but it seems the schema/table names are case-sensitive. But it looks to be working as long as the initializer does nothing.

Posted: Mon 16 Aug 2010 14:27
by AndreyR
Many thanks for your help. We have finished our investigation.
The new build will contain some dummy implementation of the DatabaseExists method.
Unfortunately, the Database.SetInitializer workaround still will be necessary.
As for the case-sensitivity, it does matter in Oracle.

Posted: Mon 16 Aug 2010 15:29
by gsogol
Thanks.