public void LeftRight()
{
using (testEntities context = new testEntities())
{
string entitySQL = "CONCAT(LEFT('foo',3),RIGHT('bar',3))";
ObjectQuery<String> query = context.CreateQuery<String>(entitySQL);
foreach (string s in query)
Assert.AreEqual("foobar", s);
entitySQL = "CONCAT(LEFT('foobar',3),RIGHT('barfoo',3))";
query = context.CreateQuery<String>(entitySQL);
foreach (string s in query)
Assert.AreEqual("foofoo", s);
entitySQL = "CONCAT(LEFT('foobar',8),RIGHT('barfoo',8))";
query = context.CreateQuery<String>(entitySQL);
foreach (string s in query)
Assert.AreEqual("foobarbarfoo", s);
}
}