public void CreateInsertQueryTest()
{
string query = @"INSERT INTO [User] (
[Name]
,[Surname]
,[Username]
,[Password]
,[Email]
,[CreatedDate]
,[Active]
)
OUTPUT inserted.[Id]
VALUES
(
@Name
,@Surname
,@Username
,@Password
,@Email
,@CreatedDate
,@Active
)";
string createdQuery = _queryCreator.CreateInsertQuery <User>();
Assert.Equal(query, createdQuery);
}