InsertOnSubmit and SQL Server Compact 3.5

[poloombard]

Hi All,
I'm trying Entity Developer 5.8 (for now the express one).
Creating model from database, that is an SQL Server Compact 3.5, everything seems good.
I Have a entity key that is COMPANYID (guid) and other fields, all nullable.
When i run this code:

Code: Select all

LocalDBDataContext ctx = new LocalDBDataContext();
COMPANY company = new COMPANY()
{
        COMPANYID = Guid.NewGuid(),
	NAME = "CompanyName"
};
ctx.COMPANIES.InsertOnSubmit(company);
ctx.SubmitChanges();

I receive an error that says

Parameterized query 'INSERT INTO T_COMPANY (COMPANYID, NAME, INTERNALCODE) VALUES (@p1, @p2, @p3)' expects a parameter value which was not supplied. Parameter name: p3

dbMonitor show a p3 parameter with DataType: String and In Value: NULL (that seems right for me).
Any idea ?
Thanks

[MariiaI]

Thank you for the report on this. We have reproduced this issue, it is specific for SQL Server Compact Edition. We will investigate it more clearly and inform you about the results as soon as possible.

[MariiaI]

The bug related to the "Parameterized query expects a parameter value which was not supplied" error when working with SQL Server Compact is fixed.

New build of LinqConnect 4.5.844 is available!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=32580.