Recommended Method for Pulling a Custom Table Data in C# ?

{% GlobalObjects.CustomTables["customtable.My_Veggies"].Items.Where("ItemID = 1")[0]["ExpirationDate"]%}

Is there a way to do this in C# not in a macro? Sorry my OP was confusing. I am actually invoking a macro method to call C# code and I want to run the query there.

Your answer is exactly what I'm looking for though, other than I need to call that in the app code not in the macro itself. I just checked for something similar in intellisense and I couldn't find any methods that I could port your code to.

Thanks for the help!

Custom Table API Examples

CustomTableItem item1 = CustomTableItemProvider.GetItems("customtable.My_Veggies")
                                                    .WhereEquals("ItemName", "SampleName")
                                                    .TopN(1)
                                                    .FirstOrDefault();

string itemTextValue = ValidationHelper.GetString(item1.GetValue("ExpirationDate"), "");

Would this work?

var item = CustomTableItemProvider.GetItems("customtable.My_Veggies").WhereEquals("ExpirationDate", DateTime.Now);

What Peter has, except you would probably do the ValidationHelper.GetDateTime if the ExpirationDate is a date type.

Him working on the e-com notification and i have a custom table (customtablename) and I can't figure out how to pass the Order.ID Order.ID in the where condition:

{% GlobalObjects.CustomTables["customtablename"].Items.Where("OrderID = '" + Order.ID + "'")[0]["FirstName"]

Order.ID in the where condition doesnt work, but if i only put {% Order.ID #%} in my html notification it return the good value...

Cause someone have a solution for that ? thank you