This is my first time I use MySQL as datastorage for my C# Application, as I've seen that there is no UNIQUEIDENTIFIER type as in SQL server I decieded to use INT with AUTO\_INCREMENT, my problem is now if I execute a INSERT, how may I get the ID of the Record I just added.

My quick and dirty solution has been to execute a SELECT MAX(ID) FROM table Statement. But this doesn't seem consistent. I belive there is a better solution something like mysql\_insert\_id() (PHP). 

Any Idea how to resolve this in C#?