• Bingo!

    Client_Interface_Name from sys.dm_exec_sessions

    Here is a sample from the column:

    .Net SqlClient Data Provider

    OLEDB

    ODBC

    NULL

    ODBC

    .Net SqlClient Data Provider

    .Net SqlClient Data Provider

    Thanks.