Code below

[patrick]

Hello

In the Code below, How do you implement DataPack?
In the Code below, dataPack = new DataPack(); and dataPack.ToOracleParameters(strQuery); <===============How do you implement DataPack and ToOracleParameters? Is there any sample code similar to this?

strQuery = @"
MERGE INTO Q_WARRANTY A USING DUAL ON (NW_CD=:NW_CD AND TRIM(NAME)=:NAME AND ITEMCODE=:ITEMCODE AND PRO= :PRO)
WHEN NOT MATCHED THEN
INSERT (NW_CD, NAME, ITEMCODE, PRO)VALUES(:NW_CD, :NAME, :ITEMCODE, :PRO)";

for (int i = 0; i < dtNwList.Rows.Count; i++)
{
string strNW_CD = dtNwList.Rows[i]["NW_CD"].ToString();

for (int j = 0; j < dtWarrnaty.Rows.Count; j++)
{
dataPack = new DataPack();

dataPack.AddProperty("NW_CD", typeof(string), strNW_CD);
dataPack.AddProperty("NAME", typeof(string), strNW_CD);
dataPack.AddProperty("ITEMCODE", typeof(string), dtWarrnaty.Rows[j]["ITEMCODE"].ToString());
dataPack.AddProperty("PRO", typeof(string), dtWarrnaty.Rows[j]["PRODUCT_CD"].ToString());

_agent.ExecuteNonQuery(strQuery, dataPack.ToOracleParameters(strQuery));
}
}

 

[Skydiver]

See approach below taken in the blog post create a query helper for Dapper. You would do the same for Oracle.

Creating a Dapper Helper C# Class to Generate Parameterized SQL

Let's create a class that can generate parameterized SQL for INSERT and UPDATE statements using Dapper!

exceptionnotfound.net

 

[cjard]

I had a brief look around the web for "datapack tooracleparameters" but turned up just one single posting in a korean forum from 2006. Perhaps not a popular library so you're going to have to provide a little more context. Personally I'd just use parameters direcly; you appear to be loading data into DataPack just so you can turn it into parameters, which seems more work than just doing it directly

 

[gulshan212]

Well, there are some logical errors in your code. Here is the correct code you can try to fix the error.

// DataPack class for parameterization
public class DataPack
{
    private Dictionary<string, object> parameters = new Dictionary<string, object>();

    public void AddParameter(string parameterName, object value)
    {
        parameters.Add(parameterName, value);
    }

    public object GetParameter(string parameterName)
    {
        return parameters[parameterName];
    }

    // Other methods or properties as needed
}

// Usage in your code
string strQuery = @"
    MERGE INTO Q_WARRANTY A USING DUAL ON (NW_CD=:NW_CD AND TRIM(NAME)=:NAME AND ITEMCODE=:ITEMCODE AND PRO=:PRO)
    WHEN NOT MATCHED THEN INSERT (NW_CD, NAME, ITEMCODE, PRO) VALUES (:NW_CD, :NAME, :ITEMCODE, :PRO)";

for (int i = 0; i < dtNwList.Rows.Count; i++)
{
    string strNW_CD = dtNwList.Rows[i]["NW_CD"].ToString();

    for (int j = 0; j < dtWarrnaty.Rows.Count; j++)
    {
        DataPack dataPack = new DataPack();

        dataPack.AddParameter("NW_CD", strNW_CD);
        dataPack.AddParameter("NAME", strNW_CD);
        dataPack.AddParameter("ITEMCODE", dtWarrnaty.Rows[j]["ITEMCODE"].ToString());
        dataPack.AddParameter("PRO", dtWarrnaty.Rows[j]["PRODUCT_CD"].ToString());

        // Pass dataPack to a method that executes the query with parameters
        _agent.ExecuteNonQuery(strQuery, dataPack);
    }
}

Thanks

 

[cjard]

Hmmm...

I have doubts