Making the EcoSpace persistent
CapableObjects Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Making the EcoSpace persistent Expand / Collapse
Author
Message
Posted 2010-04-10 18:17:37
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 2010-04-13 21:24:04
Posts: 1, Visits: 9
I'm very new to ECO and CapableObjects and I'm having some issues with persistent storage using MS-SQL.

I can create a new model with two single classes each with two string attributes, I save the model, I then generate the code and compile, so far everything is good. I then open the XXXPMP file, make sure that the sqlConnection object has a valid ConnectionString, I then validate the model and generate the model and it seems to work. The problem is that when I explore the db, it has only created a "class1" table.

If I delete all classes using CTRL+Delete, generate the code, compile, validate and  generate schema everything seems to work, but once again if I explore the db, I have a table called class1. I can delete the table using sql, generate the schema (without any objects) and the class1 table is back in the db.

I have read "Making the EcoSpace persistean.pdf". 

Post #5131
Posted 2010-04-10 19:11:31
Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 2010-08-12 17:32:24
Posts: 51, Visits: 600
Hi

You need to compile your model dll before gerenating the schema from the persistence mapper provider.

Nick

Post #5132
Posted 2010-04-11 11:56:03
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2011-07-14 17:05:00
Posts: 290, Visits: 2 617
TerryH (2010-04-10)
I'm very new to ECO and CapableObjects and I'm having some issues with persistent storageusing MS-SQL.

I can create a new model with two single classes each with two string attributes, I save the model, I then generate the code and compile, so far everything is good. I then open the XXXPMP file, make sure that the sqlConnection object has a valid ConnectionString, I then validate the model and generate the model and it seems to work. The problem is that when I explore the db, it has only created a "class1" table.

If I delete all classes using CTRL+Delete, generate the code, compile, validate and generate schema everything seems to work, but once again if I explore the db, I have a table called class1. I can delete the table using sql, generate the schema (without any objects) and the class1 table is back in the db.

I have read"Making the EcoSpace persistean.pdf".


Hi Terry

Sometimes Visual Studio caches the model DLL (it happens only very rarely for me) so if you ever see something like this occur trying restarting VS and seeing if that resolves it.



====
Pete
Post #5133
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: HansKarlsen, Jonas Hogstrom, PeterMorris

Permissions Expand / Collapse

All times are GMT +1:00, Time now is 12:25

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0,219. 7 queries. Compression Disabled.