1146 error Table does not exist EF 6 add schema.schema.tablename prefix
Posted by: efren gtz
Date: November 25, 2020 03:22PM

hi, i am trying to execute this code in asp.net
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EFSample
{
class Program
{
static void Main(string[] args)
{
try
{
using (cursomvcEntities db = new cursomvcEntities())
{
var lst = from d in db.user
where d.email == "gsefren@gmail.com" && d.password == "1234567" && d.idstate == 1
select d;
if (lst.Count() > 0)
{
user Ouser = lst.First();
Console.Write("Si entro");
}
else
{
Console.Write("No entro");
}
}
}
catch (Exception ex)
{
Console.Write("OcurriĆ³ un error :( " + ex.Message);
}
}
}
}
but give me an error the table cursomvc.cursomvc.user does not exist

i generate the Model from Database First i dont know how or why EF add twice cursomvc i really apreciate your help

Options: ReplyQuote


Subject
Written By
Posted
1146 error Table does not exist EF 6 add schema.schema.tablename prefix
November 25, 2020 03:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.