I saw this post on how to create new extended properties for SQL Server.  I can't get this to work for MySql.  Is there a different syntax?

http://community.entityspaces.net/forums/thread/50.aspx 

I want to populate a list box in this format: InquiryDate - LastName, FirstName.
 

Thanks,

King Wilder 

The only difference would be the brackets, in Microsoft SQL it's [ ] in MySql it's those string backslashes like `

However, it would help if you woud expound on "Can't get it to work" ...

Mike.Griffin:

The only difference would be the brackets, in Microsoft SQL it's [ ] in MySql it's those string backslashes like `

However, it would help if you woud expound on "Can't get it to work" ...

This is my error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near '` + ` - ` + `LastName` + `, ` + `FirstName` as `NameWithDate``  
FROM `inquiry`' at line 1 

And this is my C# method:

        public static InquiryCollection FetchAll()
        {
            InquiryCollection inqColl = new InquiryCollection();
            //
            inqColl.Query.Select(inqColl.Query.InquiryID, 
                inqColl.Query.InquiryDate, inqColl.Query.FirstName, 
                inqColl.Query.LastName, 
                "`InquiryDate` + ` - ` + `LastName` + `, ` + `FirstName` as `NameWithDate`");
            inqColl.Query.Load();

            return inqColl;
        }

Mike.Griffin:

We pass whatever is in those < > brackets straight through to the database, just get the syntax right in MySQL and plug it in there.

I had tried the < > brackets but they didn't work either.  MySql is very tricky to get right.  I did finally come up with a solution that did incorporate the brackets.

        public static InquiryCollection FetchAll()
        {
            InquiryCollection inqColl = new InquiryCollection();
            //
            inqColl.Query.Select(inqColl.Query.InquiryID, 
                inqColl.Query.InquiryDate, inqColl.Query.FirstName, 
                inqColl.Query.LastName
                , "<CONCAT(DATE(`InquiryDate`),_latin1' - ',`FirstName`,_latin1' ',`LastName`) AS NameWithDate>");
            inqColl.Query.Load();

            return inqColl;
        }

The result is: 2007-08-14 - Joe Smith

Thanks.