The importance of 'SELECT CAST(SCOPE_IDENTITY() as int)' in DapperORM

I am new to C# and definitely new to Dapper.NET. This is the first time I'm tackling ORMs and frameworks so I would like to know more about some syntax.

I've seen several INSERT queries and noticed that all have this

SELECT CAST(SCOPE_IDENTITY() AS INT);

after the INSERT INTO...; line.

I would like to know the importance, or use of this. Thank you

Edit: here is some code I've written, and is working as far as I have tested.

This is the Users.cs:

public class Users
{
    private int _uid;
    private string _fullname;
    private string _username;
    private string _passcode;

    public int uid
    {
        get { return _uid; }
        set { _uid = value; }
    }

    public string fullname
    {
        get { return _fullname; }
        set { _fullname = value; }
    }

    public string username
    {
        get { return _username; }
        set { _username = value; }
    }

    public string passcode
    {
        get { return _passcode; }
        set { _passcode = value; }
    }
}

and this is the insertUser.cs:

public Users InsertData(Users newUser)
{
    string strQry = @"INSERT INTO [Users] VALUES (@uid, @fullname, @username, @passcode);
                      SELECT * FROM [Users] WHERE [uid] = CAST(SCOPE_IDENTITY() as int);";

    using(var conn = InitOpenConn())
    {
        try
        {
            var ins = conn.Query<Users>(strQry, newUser).Single();

            return ins;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
}

and this is Program.cs:

InsertUser ium = new InsertUser();

try
{
    Users newUser = new Users
            {
                uid = 10,
                fullname = "James Bond",
                username = "james007",
                passcode = "095e3cbaf34467fbe1b0f4cd846a57460718d2b4ca504caca28ae5287e8d076db3ddadac11db87ab6ac9dac4b8d84d9a65e67e98ab6ef979c61f277f51df36f3"
            };

    Users insUsr = ium.InsertData(newUser);

    refreshTable();
    MessageBox.Show("Added !");
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}