EF: Invalid object name 'dbo.Users' RSS

• • Reply
  

  craigt-from-...

  Participant

  908 Points

  226 Posts

  EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 05:23 PM|LINK

  Hi guys.  I'm having some trouble using the Entity Framework and was hoping someone has seen this.  I've been all over Google, but nothing has worked.  I feel like it must be some kind of configuration I'm missing or something.

  The exception is a System.Data.EntityCommandExecutionException and the message is "An error occurred while executing the command definition.  See the inner exception for details."  The inner exception is: "Invalid object name 'dbo.User'."  I realize this seems to indicate that it can't find the "dbo.User" table, but it exists in my database has the "dbo" schema.  I'm using the "sa" account to connect. 

  I created the Entity Model and let it generate the create SQL for me.  I ran the script and created my tables in the database.  (only two tables)  When I "validate" from the entity model, there are no errors.  I have refreshed the model from the database and it works with no errors.  The table mappings look good.

  I get the error when I tried to retreive data or "SaveChanges."

  Everything I've seen while searching seems to indicate people have problems with the plural form of the table name (I'm not having this problem) and people having trouble getting the EF to automatically create their database. (I already have the database)

  Any ideas?

  Thanks!
  Craig 

  EF

  -Craig
• • Reply
  

  bbcompent1

  All-Star

  32974 Points

  8500 Posts

  Moderator

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 05:25 PM|LINK

  I think the word user may be sql reserved. Try making your table be named Users and try it that way.

  EF

  Mark as answer posts that helped you.
  
• • Reply
  

  craigt-from-...

  Participant

  908 Points

  226 Posts

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 05:30 PM|LINK

  Thanks for your reply.  I originally had it as "Users" for that reason, but in the process of trying everything I could, I renamed it to the singular version.  Let me try changing it back to see if something has changed.

  If I recall, I was getting the same error on my other table, "Scores."

  -Craig
• • Reply
  

  craigt-from-...

  Participant

  908 Points

  226 Posts

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 05:41 PM|LINK

  Same issue after renaming the table back to "Users."

  Does it have anything to do with how I'm making my calls for the data?:

  UserEntity user;
  using (PlusEntities dbContext = new PlusEntities())
  {
      user = dbContext.UserEntities.FirstOrDefault(u => u.FacebookId == facebookId);
  }

  Thanks!
  
  

  -Craig
• • Reply
  

  bbcompent1

  All-Star

  32974 Points

  8500 Posts

  Moderator

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 05:45 PM|LINK

  what if you make it UserEntity MyUser instead?

  Mark as answer posts that helped you.
  
• • Reply
  

  craigt-from-...

  Participant

  908 Points

  226 Posts

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 06:03 PM|LINK

  Thanks for continuing to throw out ideas; I really appreciate it.

  I changed the entity name, but I still get the "invalid object name 'dbo.Users'" error message.

  MyUser user;
  using (PlusEntities dbContext = new PlusEntities())
  {
      user = dbContext.MyUsers.FirstOrDefault(u => u.FacebookId == facebookId);
  }

  
  
  

  -Craig
• • Reply
  

  craigt-from-...

  Participant

  908 Points

  226 Posts

  Re: EF: Invalid object name 'dbo.Users'

  Aug 03, 2012 07:58 PM|LINK

  Well, due to the urgency of my project, I switched to Linq to SQL for this.  I was able to copy/paste most of my code and it worked right out of the gate.  There must be something I was missing re: EF, but I'll continue down my path of a working solution for now. :)

  I've used EF in the past with no issues, so not sure where I went wrong this time.

  Thanks!

  -Craig
  • Marked as answer by bbcompent1 on Aug 03, 2012 08:03 PM