Code-First Support

gsogol · Post by **gsogol** » Wed 21 Jul 2010 23:15

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.

AndreyR · Post by **AndreyR** » Fri 23 Jul 2010 10:53

We are in the process of testing the new Entity Framework CTP 4.
I will post here about the test results.

gsogol · Post by **gsogol** » Wed 28 Jul 2010 16:59

Any updates on the code-first EF CTP4 with dotConnect for Oracle?

AndreyR · Post by **AndreyR** » Thu 29 Jul 2010 14:50

I will post here about the results of our investigation as soon as possible.

gsogol · Post by **gsogol** » Fri 06 Aug 2010 21:26

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.

gsogol · Post by **gsogol** » Thu 12 Aug 2010 22:18

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.

gsogol · Post by **gsogol** » Fri 13 Aug 2010 19:35

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?

gsogol · Post by **gsogol** » Fri 13 Aug 2010 20:24

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.

gsogol · Post by **gsogol** » Fri 13 Aug 2010 21:05

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.

AndreyR · Post by **AndreyR** » Mon 16 Aug 2010 14:27

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.

gsogol · Post by **gsogol** » Mon 16 Aug 2010 15:29

Thanks.