Entity Framework C# Table does not updated with data in using add method

Question

I have followed by this tutorial

youtube.com/watch?v=K4x6eoG7hwY&ab_channel=SeeSharpCode

But still cant add data to my table. I did not do any manual change on this EF Code I did like on the tutorial but still cant add data to my table..

And this is all the code I have written:

my table :

CREATE TABLE [dbo].[TableTest](
    [Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] NCHAR(50) NOT NULL
)

my code :

using (Database1Entities database1Entities = new Database1Entities())            {
                TableTest t = new TableTest
                {
                    Name = "name1"
                };
                database1Entities.TableTest.Add(t);
                int c = database1Entities.TableTest.Count();
                database1Entities.SaveChanges();
            }

on the next line, c variable get value of 0... If it can help to understand the problem

int c = database1Entities.TableTest.Count();

Add TableTestModel.Context.cs class

public partial class Database1Entities : DbContext
    {
        public Database1Entities()
            : base("name=Database1Entities")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet TableTest { get; set; }
    }

In addition I am using

This app config

And using a local SQL Database with name Database1.mdf

user_13613388 · Answer

You have not yet completed the transaction when you ask the DB the entities count, change to this and tell me if it works:

using (Database1Entities database1Entities = new Database1Entities())            {
                TableTest t = new TableTest
                {
                    Name = "name1"
                };
                database1Entities.TableTest.Add(t);
                database1Entities.SaveChanges(); <----- HERE
                int c = database1Entities.TableTest.Count();
            }

Entity Framework C# Table does not updated with data in using add method

1 Answers