{"id":331,"date":"2020-07-12T10:42:31","date_gmt":"2020-07-12T05:12:31","guid":{"rendered":"https:\/\/saurabhjain1537.wordpress.com\/?p=331"},"modified":"2025-02-27T20:03:44","modified_gmt":"2025-02-27T14:33:44","slug":"in-memory-unit-test-for-net-entity-framework-application","status":"publish","type":"post","link":"https:\/\/saurabhjain.dev\/?p=331","title":{"rendered":"In-memory unit test for .Net Entity Framework Application"},"content":{"rendered":"\n

Objective<\/strong><\/p>\n\n\n\n

Creating repeatable Unit Test cases for a .Net applications which uses Entity Framework Core for database operations.<\/p>\n\n\n\n

It is recommended to write independent and repeatable test cases for the business logic. We need to handle certain cases where logic depends upon the data already existing in database. In such scenarios we can use an in-memory database like SQLite.<\/p>\n\n\n\n

Setup<\/strong><\/p>\n\n\n\n

Following tech stack is used in this example<\/p>\n\n\n\n

  1. .Net Core 3.1<\/li>
  2. NUnit 3.12<\/li>
  3. EntityFrameworkCore Sqlite 3.1.5<\/li>
  4. Visual Studio Code<\/li><\/ol>\n\n\n\n

    Application<\/strong><\/p>\n\n\n\n

    Let’s build a school management application which is going to check if there is vacancy for admission in a class.<\/p>\n\n\n\n

    Create a new dotnet console application SchoolApp:<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Add Model classes for Student and Class information:<\/p>\n\n\n\n

    \"\"
    This class contains School-Class details including Max Number of Students allowed<\/figcaption><\/figure>\n\n\n\n
    \"\"
    This class contains Student details<\/figcaption><\/figure>\n\n\n\n

    These classes are associated with database tables and have Foreign Key relationship.<\/p>\n\n\n\n

    Add AppDBContext extending EntityFrameworkCore DbContext.<\/p>\n\n\n\n

    This class contains the DbSets for Model classes<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    <\/p>\n\n\n\n

    Override DBContextOptions constructor and OnConfiguring() so that the application uses in-memory SQLite for unit testing but a different Relational database like Oracle OR SQL Server during actual Production deployment<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    <\/p>\n\n\n\n

    Define Primary Key for each Model class<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    <\/p>\n\n\n\n

    Complete Class https:\/\/gitlab.com\/saurabhjain1537\/nunit-sqlite-schoolapp\/-\/blob\/master\/SchoolApp\/Data\/AppDBContext.cs<\/a><\/p>\n\n\n\n

        public class AppDBContext:DbContext\n    {\n        public DbSet<SchoolClass> SchoolClasses { get; set;}\n        public DbSet<Student> Students {get; set;}\n\n        public AppDBContext() : base()\n        {\n        }\n\n        public AppDBContext(DbContextOptions<AppDBContext> options) : base(options)\n        {\n        }\n\n        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)\n        {\n            if(!optionsBuilder.IsConfigured)\n            {\n                optionsBuilder.UseOracle(\"TODO - connection string\");\n            }\n        }\n\n        protected override void OnModelCreating(ModelBuilder modelBuilder)\n        {\n            modelBuilder.Entity<SchoolClass>(s =>\n                {\n                    s.HasKey(k => new {k.Id});\n                });\n\n            modelBuilder.Entity<Student>(s =>\n                {\n                    s.HasKey(k => new {k.Id});\n                });\n        }\n\n    }<\/code><\/pre>\n\n\n\n
    Add Admission class having appDBOptions variable.<\/p>\n\n\n\n
    This class has a constructor to initialize DbContextOptions. The method getAppDBContext() is responsible for providing the appropriate DBContext considering if the application is actually deployed OR running unit tests.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    Add a hasVacancy() method to determine if we can allow new admission in a particular school-class.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    Complete Class https:\/\/gitlab.com\/saurabhjain1537\/nunit-sqlite-schoolapp\/-\/blob\/master\/SchoolApp\/Admission.cs<\/a><\/p>\n\n\n\n
        public class Admission\n    {\n        private DbContextOptions<AppDBContext> appDBOptions;\n\n        public Admission()\n        {\n            this.appDBOptions = null;\n        }\n\n        public Admission(DbContextOptions<AppDBContext> appDBOptions)\n        {\n            \/\/This constructor is used for Unit testing\n            this.appDBOptions = appDBOptions;\n        }\n\n        private AppDBContext getAppDBContext()\n        {\n            if(this.appDBOptions == null)\n            {\n                return new AppDBContext();\n            }\n            else\n            {\n                return new AppDBContext(this.appDBOptions);\n            }\n\n        }\n\n        public bool hasVacancy(string Standard)\n        {\n            bool hasVacancy = false;\n\n            using(var context = getAppDBContext())\n            {\n                hasVacancy = context.SchoolClasses\n                                        .Where( c => c.Standard == Standard && c.MaxNumStudents > c.Students.Count)\n                                        .Count()\n                              > 0;\n\n            }\n\n            return hasVacancy;\n\n        }\n\n    }<\/code><\/pre>\n\n\n\n
    Test Project<\/strong><\/p>\n\n\n\n
    \"\"
    Create a new dotnet nunit application SchoolApp.Tests<\/figcaption><\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    \"\"
    Add reference to SchoolApp project<\/figcaption><\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    Add Test class AdmissionTest.<\/p>\n\n\n\n
    This class uses in-memory SQLite to initialize an Object of Admission class.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SQLite connection DataSource=:memory:<\/em> signifies in-memory usage<\/p>\n\n\n\n
    Add a test case:<\/p>\n\n\n\n
    1. Inserts a new SchoolClass in database<\/li>
    2. Checks for Vacancy in the SchoolClass<\/li>
    3. Expects availability to be True<\/li><\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      <\/p>\n\n\n\n
      Add a test case:<\/p>\n\n\n\n
      1. Inserts a new SchoolClass in database<\/li>
      2. Adds Max allowed number of students to the SchoolClass<\/li>
      3. Checks for Vacancy in the SchoolClass<\/li>
      4. Expects availability to be False<\/li><\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/p>\n\n\n\n
        Complete Test Class https:\/\/gitlab.com\/saurabhjain1537\/nunit-sqlite-schoolapp\/-\/blob\/master\/SchoolApp.Tests\/AdmissionTest.cs<\/a><\/p>\n\n\n\n
            public class AdmissionTest\n    {\n        DbContextOptions<AppDBContext> configOptions = null;\n        private Admission admission;\n\n        [SetUp]\n        public void Setup()\n        {\n            var connection = new SqliteConnection(\"DataSource=:memory:\");\n\n            configOptions = new DbContextOptionsBuilder<AppDBContext>().UseSqlite(connection).EnableSensitiveDataLogging().Options;\n\n            admission = new Admission(configOptions);\n\n        }\n\n        [Test]\n        public void hasVacancy_True()\n        {\n            using (var context = new AppDBContext(configOptions))\n            {\n                context.Database.OpenConnection();\n                context.Database.EnsureCreated();\n\n                context.SchoolClasses.Add( new SchoolClass{ Id = 1, Standard = \"6\", Section = \"B\", MaxNumStudents = 10 });\n\n                context.SaveChanges();\n\n            }\n\n            var hasVacancy = admission.hasVacancy(\"6\");\n\n            Assert.AreEqual(true, hasVacancy);\n\n        }\n\n        [Test]\n        public void hasVacancy_False()\n        {\n            using (var context = new AppDBContext(configOptions))\n            {\n                context.Database.OpenConnection();\n                context.Database.EnsureCreated();\n\n                var schoolClass6B = new SchoolClass{ Id = 1, Standard = \"6\", Section = \"B\", MaxNumStudents = 5 };\n                context.SchoolClasses.Add(schoolClass6B );\n                context.Students.Add( new Student { Id = 1, Name = \"a\", schoolClass = schoolClass6B});\n                context.Students.Add( new Student { Id = 2, Name = \"b\", schoolClass = schoolClass6B});\n                context.Students.Add( new Student { Id = 3, Name = \"c\", schoolClass = schoolClass6B});\n                context.Students.Add( new Student { Id = 4, Name = \"d\", schoolClass = schoolClass6B});\n                context.Students.Add( new Student { Id = 5, Name = \"e\", schoolClass = schoolClass6B});\n\n                context.SaveChanges();\n\n            }\n\n            var hasVacancy = admission.hasVacancy(\"6\");\n\n            Assert.AreEqual(false, hasVacancy);\n\n        }\n\n    }<\/code><\/pre>\n\n\n\n
        Execute Tests<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/p>\n\n\n\n
        Result<\/strong><\/p>\n\n\n\n
        We have successfully created a SchoolApp to validate school Admissions and prepared repeatable test cases using SQLite in-memory database.<\/p>\n\n\n\n
        The complete code this Example project is available at https:\/\/gitlab.com\/saurabhjain1537\/nunit-sqlite-schoolapp\/-\/tree\/master<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
        Objective Creating repeatable Unit Test cases for a .Net applications which uses Entity Framework Core for database operations. It is recommended to write independent and repeatable test cases for the business logic. We need to handle certain cases where logic depends upon the data already existing in database. In such scenarios we can use an … Continue reading In-memory unit test for .Net Entity Framework Application<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[6,17,19,22,29,40,57,61],"class_list":["post-331","post","type-post","status-publish","format-standard","hentry","category-dotnet","tag-net","tag-core","tag-dotnet","tag-entity-framework","tag-in-memory","tag-nunit","tag-sqlite","tag-unit-test"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/posts\/331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=331"}],"version-history":[{"count":2,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions"}],"predecessor-version":[{"id":784,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions\/784"}],"wp:attachment":[{"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saurabhjain.dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}