Your question has been submitted and is awaiting moderation.
I am trying to develop a new Module using DAL 2 and I want to get Max of the ID.
public int getMax(int moduleId)
using (IDataContext db = DataContext.Instance())
t = db.ExecuteQuery(CommandType.Text, "select MAX(ItemId) from Itemes");
but it didn't work can any one give the correct syntax. please.