สอบถามเรื่องการเขียนคำสั่งให้โปรแกรมส่งค่า Identity กลับคืนมา

   public Boolean InsertData()
        {
            strSql = "INSERT INTO A_TEST(PREFIX, FIRST_NAME, LAST_NAME, TELEPONE, EMAIL) VALUES ";
            strSql +="('" + A1 + "', ";
            strSql += "'" + A2 + "', ";
            strSql += "'" + A3 + "', ";
            strSql += "'" + A4 + "', ";
            strSql += "'" + A5 + "')";
            if (ExcuteCommand(CommandType.Text, strSql) == true)
                { return true; }
            else
                { return false; }
        }
            

            public Boolean ExcuteCommand(CommandType strCommandType,
                                                           string strSql)
            {
                using (myConnection = new SqlConnection(strConnection))
                {
                    myConnection.Open();
                    myTransaction = myConnection.BeginTransaction();
                    try
                    {
                        int intResult;
                        myCommand = new SqlCommand(strSql, myConnection, myTransaction);
                        intResult = myCommand.ExecuteNonQuery();
                        if (intResult > 0)
                        {
                            myTransaction.Commit();
                            return true;
                        }
                        else
                        {
                            myTransaction.Rollback();
                            return false;
                        }                    
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
            }