>1. Can MM.Net automatically check for duplicate record if a user trying to add new record into a table? Do I need to add my own sql to check it?

You can add a check in your business rule object to determine if a duplicate record exists...do you not have unique, system-generated primary keys?

>2. Can MM.Net autimatically check whether the record is referenced in child table before update/delete? Is that I establish business object relationships between parent and child tables is enough? Do I need to add my own sql?

I need more information to understand this scenario...

>3. How can I retrieve the foreign key description from another table? Does MM.Net provide any special function to do that?


You can simply retrieve the description by using a join in your stored procedure or dynamic SQL.

Best Regards,