Thread: Linq Problem
View Single Post
  #1 (permalink)  
Old June 9th, 2010, 03:59 AM
barakros barakros is offline
Authorized User
Points: 154, Level: 3
Points: 154, Level: 3 Points: 154, Level: 3 Points: 154, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 34
Thanks: 5
Thanked 0 Times in 0 Posts
Default Linq Problem

Hi Imar
I am trying to use linq and have the following problem:
I tried to do something like the example in chapter 13 with the Genres and Reviews , where we show the Genre and reviews in buletedlist inside a repeater

I am trying to do the same thing with my DB with 2 tables with a string common field.

I am also not using a SQL file but using a connection to the SQLEXPRESS
the provider is .NET Framework Data Provider for SQL Server
and the connection string :
Data Source=BARAK-LAPTOP\sqlexpress;Initial Catalog=Cosmo;Integrated Security=True

the problem is that I can't get the Child Table in the linq command
the intellisense does not show it and the link between the tables does not work - I made it as in the book example: parent table field to child table field on the same field (varchar(8))

also tried it with an integer field and also did not worked
linq does not support this provider?
any ideas?

TIA
BARAK
Reply With Quote