Exemplo n.º 1
0
        public void GenerateGetAllQuery_CustomColumnNames_Valid()
        {
            // Arrange
            var generator = new SqlQueryGenerator <CustomColumnNamesEntity>("dbo", "Orders");

            // Act
            var selectQuery = generator.GenerateGetAllQuery();

            // Assert
            Assert.Equal($"SELECT [dbo].[Orders].[OrderId] AS [Id], [dbo].[Orders].[DateCreated] AS [Date] FROM [dbo].[Orders];", selectQuery);
        }
Exemplo n.º 2
0
        public void GenerateGetAllQuery_ProperTableName_Valid()
        {
            // Arrange
            var generator = new SqlQueryGenerator <HeapEntity>("dbo", "Users");

            // Act
            var selectQuery = generator.GenerateGetAllQuery();

            // Assert
            Assert.Equal($"SELECT [dbo].[Users].[Username], [dbo].[Users].[Password] FROM [dbo].[Users];", selectQuery);
        }