This is a migrated thread and some comments may be shown as answers.

[Solved] Errors in updating Database from Model

7 Answers 143 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Michael
Top achievements
Rank 1
Michael asked on 11 Dec 2010, 02:08 AM
I'm getting the following weird error when trying to update a SQL CE Db using ORM.

The metadata for field 'name' of Class 'Blah" cannot be initialized: Type converter initialization failed. The convertoer with name SqlCeStringConverter does not convert from CLR type System.Int32 to SQL type nvarchar. Version=2010.3.1125.1

I find this confusing as the name field is string??

Also can anyone direct me on how to map money fields in ORM. I've an existing class that uses doubles.

7 Answers, 1 is accepted

Sort by
0
Jan Blessenohl
Telerik team
answered on 14 Dec 2010, 02:26 PM
Hi Michael,
I tried to reproduce your problem, but had no luck. Can you give me your persistent classes project so that I can debug here?

System.Double is mapped by default to the sql ce type 'float'. The range should match and i cannot see problems there.

Kind regards,
Jan Blessenohl
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Michael
Top achievements
Rank 1
answered on 15 Dec 2010, 12:12 AM
I'llk try to replicate it...I managed to get it to do it 3 timnes prior. Ive now deleted the rLinq file a third time and created the tables manually which worked.

There was some issue in a money datatype from sql CE i think??
i should be able to replicate what i did...just need time
8)

ty
0
Jan Blessenohl
Telerik team
answered on 15 Dec 2010, 05:40 PM
Hi Michael,
Please take your time, I tried some combinations but it worked fine so far.

Kind regards,
Jan Blessenohl
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Michael
Top achievements
Rank 1
answered on 16 Dec 2010, 02:40 PM
OK more weird behaviour.
The EntityDiagrams.cs file had NO code in it?
I deleted the rlinq & the connection strings in app config...

however the generated classes didnt appear in my project and its added an extra connection string to the app config?

and it's back to none of the inheritance working...what can i send?
0
Michael
Top achievements
Rank 1
answered on 17 Dec 2010, 01:00 AM
OK i broke it again

Here's the scenario:

Created a table with3 fields
ID
PoderID :int
CapsuleID :int
Capacity:Decimal

(it seems decimal is the culprit)

I then R-click on the entity & select "create Table..."

and everything maps except the decimal property which comes up blank & when i mouse over it ...
DATAGRIDVIEW Default Error Dialog

The following exception occured in the DataGridView:

System.ArgumentException: DataGridViewComboBoxCell value is not valid
0
Michael
Top achievements
Rank 1
answered on 17 Dec 2010, 01:07 AM
Gets worse...

I manually created a table and it mapped ok

created the join...the popup showed & i selected the fields to join.... closed and VS broke...its currently restarting and tryiong to recover the rlinq file

Yup tried a second time
VS crashed
0
Damyan Bogoev
Telerik team
answered on 17 Dec 2010, 11:28 AM
Hi Michael,

1.   It seems that there are problems related to the code generation. The cause for the wrong behavior could be invalid Meta model stored within the rlinq file. I should ask you to provide us a with a sample application which demonstrates that error.
2.   In the Table Editor, the SQL types combo box is bound to a collection of database specific types. The Numeric and Decimal SQLCe data types are not part of this collection which leads to the error. This is a known issue which is already fixed and will be part of the product in the next internal build.
3.   Could you please share some more details regarding the classes in the project and steps to reproduce the wrong behavior which forces the Visual Studio instance to crash?
I am looking forward to hearing from you.

Best wishes,
Damyan Bogoev
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Tags
General Discussions
Asked by
Michael
Top achievements
Rank 1
Answers by
Jan Blessenohl
Telerik team
Michael
Top achievements
Rank 1
Damyan Bogoev
Telerik team
Share this question
or