AppDB being depricated. How do you use ApplicationDB?

Stephen Cena

CSI 9.01.01 on prem. I have a need to call some SQL functions/stored procedures in SQL from within my C# IDO Extension Class. Originally, I had my Extension Classes using ExtensionClassBase. This gave me access to CreateAppDB(). I'm now using IDOExtensionClass which now uses the CreateApplicationDB(). I believe this is what I'm supposed to be doing, as I found this section in the IDO guide :

I cannot get anything to run properly if I use CreateApplicationDB(). Instead of using Microsoft SQL calls/libraries its using IDCommand/etc.

Should I be using CreateApplicationDB? Is CreateAppDB being depricated? Does anyone have any working examples of using CreateApplicationDB to call SQL SP's and functions?

Legacy Contributor

[IDOMethod(Flags = MethodFlags.CustomLoad, MessageParm = "Infobar")]
public DataTable GetCustomersSQL(string site, ref string Infobar)
{
    DataTable data = new DataTable();

    try
    {
        using (ApplicationDB appDB = IDORuntime.Context.CreateApplicationDB())
        {
            using (IDbCommand cmd = appDB.CreateCommand())
            {
                StringBuilder sqlStr = new StringBuilder();
                sqlStr.AppendLine("SELECT cust_num, cust_seq, name ");
                sqlStr.AppendLine("FROM custaddr_mst ");
                sqlStr.AppendLine($"WHERE site_ref = {SqlLiteral.Format(site)} AND cust_seq = 0 ");
                sqlStr.AppendLine("ORDER BY cust_num ");

                cmd.CommandText = sqlStr.ToString();
                cmd.CommandType = CommandType.Text;

                using (IDataReader reader = appDB.ExecuteReader(cmd))
                {
                    data.Load(reader);
                }

            }
        }
    }
    catch (Exception ex)
    {
        Infobar = ex.Message;
    }

        return data;
}