Welcome Guest Search | Active Topics | Log In | Register

Update model from Database Options
Sysnelli
#1 Posted : Tuesday, February 02, 2010 5:07:16 AM
Rank: Member

Groups: Member

Joined: 2/2/2010
Posts: 3
Points: 9
Does VistaDB support 'Update model from Database' feature in EF4?
I'm receiving this message:

" ... 'System.ArgumentNullException' 'Value Cannot be Null'
Parameter name: providerInvariantName"
js_vistadb
#2 Posted : Tuesday, February 02, 2010 2:34:24 PM
Rank: VistaDB Staff

Groups: Administration, VistaDB Staff

Joined: 8/13/2006
Posts: 3,372
Points: 3,911
Location: Mount Dora, Florida
What build are you using? Was the EF model originally built against VistaDB? You can't try to change the model to point to us and then update, that won't work.

I don't know of any issues with just the general update against a model. If you have something specific that is not working open a ticket for us to look at it.

Jason Short

Sysnelli
#3 Posted : Sunday, February 07, 2010 4:29:29 AM
Rank: Member

Groups: Member

Joined: 2/2/2010
Posts: 3
Points: 9
I'm evaluating VistaDB 4.0 Trial version (4.0.12.1). The model was originally generated from a VistaDB database without any problem; after adding new tables to the database and lunching 'Update model from database' I receive the error message. Of course database is closed before lunching!!!

<< An error occured while connecting to the database. The database might be unavailable. An exception of type 'System.ArgumentNullException' occured. The error message is 'Value Cannot be Null'
Parameter name: providerInvariantName" >>

I'm using Visual Studio 2010 Beta 2
js_vistadb
#4 Posted : Thursday, February 11, 2010 4:40:42 PM
Rank: VistaDB Staff

Groups: Administration, VistaDB Staff

Joined: 8/13/2006
Posts: 3,372
Points: 3,911
Location: Mount Dora, Florida
I'm not aware of any issues with update from a database, but EF has a LOT of weird problems updating an existing model from a database.

If you change the constraints on a column, it doesn't handle that. If you change the type of the column, or just add one additional column...

Even with our SQL Server EF models we usually end up regenerating at some point because the model file will stop rendering in EF (VS 2008 and 2010). I just got the RC of 2010, have not played with it enough to say if they fixed it or not.

Jason Short

Sysnelli
#5 Posted : Friday, February 12, 2010 5:04:11 AM
Rank: Member

Groups: Member

Joined: 2/2/2010
Posts: 3
Points: 9
As far as I've been testing last 2010 beta, the Update Option has been improved and EF in general.

Any way! We have been seeking for an embedded .NET database with small footprint and zero server install for a long time. VistaDB is a true response for that, and we will surely purshase an use it in our medium size business softwares to be migrated to .NET (AS LONG AS IT SUPPORTS Entity Framework).

Keep the job done! VistaDB is a true need for many developers
js_vistadb
#6 Posted : Friday, February 12, 2010 12:20:56 PM
Rank: VistaDB Staff

Groups: Administration, VistaDB Staff

Joined: 8/13/2006
Posts: 3,372
Points: 3,911
Location: Mount Dora, Florida
Thanks for the kind words! We don't hear a lot from people using EF.

Did you get your problem resolved? Or can you build a solution to demonstrate the problem to us?

I just did an update from a database where I added a new table to the database and it had a FK to an existing table. That update worked (allowed me to add the table and it showed the relationship).

Jason Short

Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.067 seconds.