Example #1
0
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity <Course>().ToTable("Course");
            modelBuilder.Entity <Enrollment>().ToTable("Enrollment");
            modelBuilder.Entity <Student>().ToTable("Student");

            InitialStoreProcedure initStore = new InitialStoreProcedure(connectionString);

            initStore.BuildStore("spStudentSelect", "SELECT ID, FirstMidName, LastName, EnrollmentDate FROM Student");
            initStore.BuildStore("spStudentSelectByID", "SELECT ID, FirstMidName, LastName, EnrollmentDate FROM Student WHERE ID = @ID", "@ID INT");
            initStore.BuildStore("spStudentInsert", "INSERT INTO Student (ID, LastName, FirstMidName, EnrollmentDate) VALUES (@ID, @LastName, @FirstMidName, @EnrollmentDate)", "@ID INT, @LastName NVARCHAR(MAX), @FirstMidName NVARCHAR(MAX), @EnrollmentDate DATETIME");
        }
        public DapperDatabaseContextTest()
        {
            DbInitializer.Initialize(context);

            //If Database had created then we begin create stores
            if (InitialStoreProcedure.CheckExistDB(connectionString))
            {
                InitialStoreProcedure initStore = new InitialStoreProcedure(connectionString);
                initStore.BuildStore("spStudentSelect", "SELECT ID, FirstMidName, LastName, EnrollmentDate FROM Student");
                initStore.BuildStore("spStudentSelectByID", "SELECT ID, FirstMidName, LastName, EnrollmentDate FROM Student WHERE ID = @ID", "@ID INT");
                initStore.BuildStore("spStudentSelectTotalStudent", "SELECT COUNT(ID) FROM Student");
                initStore.BuildStore("spStudentInsert", "DECLARE @StudentID INT \n IF @ID IS NULL OR @ID <= 0 \n BEGIN \n INSERT INTO Student(FirstMidName, LastName, EnrollmentDate) \n VALUES(@FirstName, @LastName, @EnrollmentDate) \n SET @StudentID = @@ROWCOUNT \n END \n ELSE \n BEGIN \n UPDATE Student SET FirstMidName = @FirstName, LastName = @LastName, EnrollmentDate = @EnrollmentDate \n SET @StudentID = @ID \n END \n SELECT @StudentID", "@ID INT = NULL, \n @FirstName NVARCHAR(50), \n  @LastName NVARCHAR(50), \n  @EnrollmentDate DATETIME");

                initStore.BuildStore("spStudentExecNonQueryInsert", "INSERT INTO Student (FirstMidName, LastName, EnrollmentDate) VALUES (@FirstMidName, @LastName, @EnrollmentDate) Select Id from Student", "@FirstMidName NVARCHAR(MAX),@LastName NVARCHAR(MAX),@EnrollmentDate DATETIME ");
                initStore.BuildStore("spStudentExecNonQueryUpdate", "UPDATE Student SET FirstMidName = @FirstMidName WHERE ID = @ID", "@ID INT, @FirstMidName NVARCHAR(MAX)");
                initStore.BuildStore("spStudentExecNonQueryDelete", "DELETE Student WHERE ID = @ID", "@ID INT");
            }
            else
            {
                Console.WriteLine("Database must be created before create stored procedure.");
            }
        }