Linq to SQL does not return INT values from SQL Server

Hello

I have found the problem and it was a very simple one.  The word "int" should be "Int" in the XAML code, since the name of the table in SQL Server is called "Key_Word_Int". 

A simple mistake which I will take note of for future reference.

The code should read like this:


 

Yes, I do feel dumb!

Thanks

C

Hi

Good spot but no cigar.  I took out the extra space and still got nothing.  I think it has to be something with the table in SQL Server Express.  I going to recreate the Database and see what happens.

I will class this post as closed.

Thanks

C

Hello

It must be something wrong with the table in SQL server express.  I created another Datagrid with WPF using Northwind.  From the Orders table I choose EmployeeID.  EmployeeID has the exact configuration as Key_Word_Int in SQL Server express.

EmployeeID returns INT values without any issues.  Bashing my head against a brick wall is very appealing at this moment.

Thanks for your time, I am going to start from scratch again.

Cheers

C

No. Visual C# 2008 does not make any difference here.

Thanks for the replies.

Suthish:  Yes the dbMS contains that record.  I created a table with 2 columns i.e. Key_Word_int, Key_Word_Ref.

Murali:  I will try selecting the particular int column.  I will do this when I get back from work.

I am using C# 2008 Express (would that make any difference?).

Thanks

C

var dbMS = (from p in cd.Key_Words
  select p.Key_Word_int).Take(10);

Please try to select only the particular int column and check the result in dbMS object.