Unanswered: Will you help me with MSSQL Syntax in VB?
This query I had to modify because the MIMETYPE was "audio/x-mpeg" instead of "audio/mpeg". It was just a temporary fix because I need it to find all the mpeg types, I think there are about 10 of them. I can't seem to find the syntax to make the query look for anything that begins with "audio/" or to check a set of values for true.
Can you help me with my ignorance?
Dim db As New DAL.AllstarRadioDataContext
Dim Content = (From c In db.fs_Contents _
Where c.ProgramID = _ProgramID _
And c.DisabledBy Is Nothing _
And c.fs_ContentFiles.Count > 0 _
And c****nDate <= Date.Today _ And c.fs_ContentFiles.Where(Function(f) f.FileMIMEType = "audio/x-mpeg").Count > 0 _
Order By c****nDate Descending).Take(1).FirstOrDefault