Combine Insert and Select into one call?? But of course - all the time. It's nothing new.
We've been doing that in ASP.NET ever since 2005 when we started working with Visual Studio 2005 and using the strongly typed datasets. All Insert and Update procedures return a dataset of the updated/inserted rows, it's built in - create a new table adapter in a dataset and the wizard kicks in, select Create New Stored Procedures, pick Advanced Options on the next screen and you can select whether or not to refresh the data table, which adds the select statement into the stored procedure after the insert or update. We always do.
Once the procedures have been created I go in and manually refine and tune them, adding error handling and often changing the select query to return fully looked up (denormalised) data. You just have to ensure you have the same select query in all the various select/insert/update stored procs for that table adapter.