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); }
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); }