ansaurus

Question

LINQ to SQL, Failed on db.SubmitChanges()

Answer 1

A:

Looks like your database schema doesn't match your DBML. Double check your property types and attributes match.

slf 2009-02-17 21:23:37

I Just drag and drop from server explorer

Angel Escobedo 2009-02-17 21:43:03

Answer 2

A:

Is the estadoestudio Field from your EXAMENXATENCION Table a VarChar(1) ? if so the LINQ to SQL designer has interpreted this as a Char field, edit your column in your DBML designer or underlying XML to System.String instead of System.Char. I would also recommend this for any other VarChar(1) fields you are representing in LINQ to SQL if the field is nullable as you cannot have a null char.

Quintin Robinson 2009-02-17 21:49:23

yes, is a State, like 'P' is Paid ...

Angel Escobedo 2009-02-17 22:00:40

well, I open a new project with the same WPF App and then with one button update random row in a table from my database, and works! Is this a bug?

Angel Escobedo 2009-02-17 22:01:45

Then you should just need to open your DBML designer, click on the columns that are defined as varchar(1) or nvarchar(1) in your DB and change the type in the properties window from System.Char to System.String

Quintin Robinson 2009-02-17 22:02:19

I did it already, and error continues

Angel Escobedo 2009-02-17 22:05:26

Bleh.. I should have read your error message better. It says int32 to string. Can you right click your DBML and say open with and select XML Viewer and paste the XML for the relevant tables as well as the SQL definitions so we can see where the mismatch is occuring?

Quintin Robinson 2009-02-17 22:10:30

ok maybe this is a bug, I Have the same XML in both project (in working and not working ones)

Angel Escobedo 2009-02-17 22:20:04

Well can't confirm or deny it's a bug, but I fail to see a problem from here. Hopefully you can salvage your elements into that new project that works correctly.

Quintin Robinson 2009-02-17 22:28:51

Answer 3

A:

Solution:

Open a new Project, add new Linq2SQL Model and then copy and paste XML and designer.cs file, rename on this line :

public DB() :
            base(global::SRIMedico.Properties.Settings.Default.DATABASEGENERALConnectionString, mappingSource)
        {
            OnCreated();
        }

where SRIMedico will be your Default Namespace... and DATABASEGENERALConnectionString will be your ConnectionString name..

Hopes help

Angel Escobedo 2009-02-17 22:43:37

ansaurus

tags:

views:

answers:

LINQ to SQL, Failed on db.SubmitChanges()

related questions