Default value + linq insertion

[Suraj]

Hi frens,
I have created a table in SQL server with 10 columns with char
datatype with default value ' ' (empty).

For the table, i insert values into 6 columns using the below code in
c# using linq

tblRecordType1 objtblRecordType1 = new tblRecordType1();
objtblRecordType1.AccountNumber = 1233;
objtblRecordType1.AccountNumber2 = 1233;
objtblRecordType1.AccountNumber3 = 1233;
objtblRecordType1.AccountNumber4 = 1233;
objReadTextFileDataContext.tblRecordType1s.InsertOnSubmit(objtblRecordType1);
objReadTextFileDataContext.SubmitChanges();

The above code will insert records into 4 columns only.

since, I had set default value to ' ' for all columns, I expected the
remaining 6 columns to have ' '. But, here they have null.

Can you please have a look and advice.

Regards,
Suraj

[Rene Felix Correa]

You will need to put explict in the code or you can change and put this in the constructor of the class.

--
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetde...@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopm...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net

---
You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotnetdevelopm...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Rene Felix Correa
Analista Desenvolvedor
http://renefc3.wordpress.com