Adding constants to select statements

Posts   
 
    
Dan Suitor
User
Posts: 14
Joined: 07-Feb-2008
# Posted on: 16-Jul-2019 18:27:05   

I could not find anything on this topic. Is there a way to add to a constant to a select statement? For example, SELECT ‘Constant’ AS ConstantField? I’m trying to pass information in the query that will then be evaluated on SQL server. I tried to add it in an overridden CreateSelectDQ method, but it results in an exception (The length of the passed in values array is: 27 while the number of tracked fields is 26).

Thanks Dan

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 17-Jul-2019 00:37:50   

Example in Linq:

using (var adapter = new DataAccessAdapter())
{
    var linqMetaData = new LinqMetaData(adapter);

    var q = from c in linqMetaData.Customer
            select new { Name = c.ContactName, Type = "T1" };

    var list = q.ToList();
}