public void GenerateGetQuery_NoPrimaryKey_Valid() { // Arrange var generator = new SqlQueryGenerator <HeapEntity>("dbo", "Users"); // Act var query = generator.GenerateGetQuery(); // Assert Assert.Equal("SELECT [dbo].[Users].[Username], [dbo].[Users].[Password] FROM [dbo].[Users] WHERE [dbo].[Users].[Username] = @Username AND [dbo].[Users].[Password] = @Password;", query); }
public void GenerateGetQuery_CompositePrimaryKey_Valid() { // Arrange var generator = new SqlQueryGenerator <CompositePrimaryKeyEntity>("dbo", "Users"); // Act var selectQuery = generator.GenerateGetQuery(); // Assert Assert.Equal($"SELECT [dbo].[Users].[Username], [dbo].[Users].[Password], [dbo].[Users].[DateCreated] FROM [dbo].[Users] WHERE [dbo].[Users].[Username] = @Username AND [dbo].[Users].[Password] = @Password;", selectQuery); }
public void GenerateGetQuery_CustomColumnNames_Valid() { // Arrange var generator = new SqlQueryGenerator <CustomColumnNamesEntity>("dbo", "Orders"); // Act var selectQuery = generator.GenerateGetQuery(); // Assert Assert.Equal($"SELECT [dbo].[Orders].[OrderId] AS [Id], [dbo].[Orders].[DateCreated] AS [Date] FROM [dbo].[Orders] WHERE [dbo].[Orders].[OrderId] = @Id;", selectQuery); }
public void GenerateGetQuery_SinglePrimaryKey_Valid() { // Arrange var generator = new SqlQueryGenerator <SinglePrimaryKeyEntity>("dbo", "Users"); // Act var selectQuery = generator.GenerateGetQuery(); // Assert Assert.Equal($"SELECT [dbo].[Users].[Id], [dbo].[Users].[Username], [dbo].[Users].[Password] FROM [dbo].[Users] WHERE [dbo].[Users].[Id] = @Id;", selectQuery); }