public void TranslateExpressionForXmlPathTest()
{
// Arrange.
SQLDataService ds = new MSSQLDataService();
bool pointExistInSourceIdentifier;
string expectedResult = "(select '' as [@caption], [KP].[ФИО] as [@value] For XML PATH ('element'), TYPE)";
// Act.
string result = ds.TranslateExpression(expectedResult, string.Empty, "exteranlnamewithpoint.", out pointExistInSourceIdentifier);
// Assert.
Assert.Equal(string.Format("({0})", expectedResult), result);
}
public void TranslateExpressionTest()
{
// Arrange.
SQLDataService ds = new MSSQLDataService();
bool pointExistInSourceIdentifier;
string expectedResult =
"(select exteranlnamewithpoint.\"Фамилия\"+exteranlnamewithpoint.\"Имя\"+exteranlnamewithpoint.\"Отчество\" from TableName where primaryKey=StormMainObjectKey)";
// Act.
string result = ds.TranslateExpression(
"select @Фамилия@+@Имя@+@Отчество@ from TableName where primaryKey=StormMainObjectKey", string.Empty,
"exteranlnamewithpoint.", out pointExistInSourceIdentifier);
// Assert.
Assert.Equal(expectedResult, result);
}
