Code: Select all
select Username, count(Username) as cnt
from MacAddresses
group by Username
Code: Select all
var
Query : ILinqQueryable;
Mac : IMacaddressExpression;
begin
Mac := MacDataContext1.Macaddress;
Query := From(Mac).GroupBy(Mac.Username).Select([Mac.Username]);
EntityDataSet1.SourceCollection := MacDataContext1.GetEntities(Query);