Linq issue retrieving single value from SQL Server

Question

Hey Guys, having an issue with Linq-to-SQL, I am basically doing the following but it is saying it is "UserProfile does not contain definition for Username" in the current context where I wrote "u.Username" but it does exist I have added UserProfile table to MyDbml.dbml and if I connect to another table it works fine.

TiamoDataContext context = new TiamoDataContext();

var user = (from u in context.UserProfiles
           where u.Username == UsernameLabel
          select u).FirstOrDefault();

I am flustered by what small detail I have missed out to get this to work, anyone have any clues it would be much appreciation.

Please post the content of UserProfile

Oskar Kjellin
– Oskar Kjellin

2010-04-16 15:56:47 +00:00
Commented Apr 16, 2010 at 15:56 — Oskar Kjellin
– Oskar Kjellin, Commented Apr 16, 2010 at 15:56

Justin Niessner · Accepted Answer · 2010-04-16 15:56:12Z

2

If the compiler says it doesn't exist, then it doesn't exist.

Make sure you check case. Username could really be username. Also make sure you properly added the UserProfiles table from the database.

Without more code (or screenshots of the DBML), there's not much more we can suggest.

answered Apr 16, 2010 at 15:56

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anicho Over a year ago

When you mentioned screenshots of DBML I thought I would remove and re-add UserProfile table and it works like a charm do not know what caused that thanks for your time. I think what caused it is that I am using the design view when I save in design view it mentions the .cs file for the dbml was edited outside the source editor and if I want to update it I need to click Yes to All which I may have slipped last time i did that.

Anicho Over a year ago

Okay falsify last statement UserProfile1 needs to be its name dont know why it doesn't like UserProfile it works for me so I am happy.

Collectives™ on Stack Overflow

Linq issue retrieving single value from SQL Server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related