Entity framework returns entity which doesn't exist in database

[dupond martin]

I got a very strange behavior with EF6. I have an entity which insertion failed, but when i enumerate the entities, the first time after that, I retrieve the entity, even if i create a new context
Here a sample code in C#


MyDbContext ctx = new MyDbContext();
Category category = new Category()
{
Name = "TEST INSERTION FAILED",
TranslationCategories = new List<TranslationCategory>()
{
new TranslationCategory()
{
LangId = "FR",
Name= "FR translation"
}
}
};
try
{
ctx.Categories.Add(category);
await ctx.SaveChangesAsync();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
// throw exception because "TranslationCategory" table doesn't exist in DB
}
MyDbContext ctx2 = new MyDbContext();
foreach(var o in ctx2.Categories.ToList())
{
Console.WriteLine(o.Name);
//output : "TEST INSERTION FAILED" + categories stored in DB
// Why category "TEST INSERTION FAILED" in ctx2.Categories ?
}
Console.WriteLine("****************");
foreach (var o in ctx2.Categories.ToList())
{
Console.WriteLine(o.Name);
// ouput : only categories stored in DB
}


The same code, with same schema in sql server, doesn't reproduce this bug.