public ErrorCode CreateOrUpdateValues(CacheTableStructXml cacheTableStructXml)
{
RemoveNotAvalibleColumns(cacheTableStructXml, new[] { "Id" });
const string sql = "EXECUTE [dbo].[P_CacheDb_UpdateValues] @CacheTableStructXml";
string xmlString = cacheTableStructXml.ToString();
ErrorCode result = this.StoredProcedureVoid(sql, new
{
CacheTableStructXml = xmlString
});
return(result);
}
public ErrorCode CreateOrUpdateTable(CacheTableStructXml cacheTableStructXml)
{
RemoveNotAvalibleColumns(cacheTableStructXml, new[] { "Id", Constants.BarCodeFieldName, "ItemUrl" });
const string sql = "EXECUTE [dbo].[P_CacheDb_CreateTable] @CacheTableStructXml";
string xmlString = cacheTableStructXml.ToString();
ErrorCode result = this.StoredProcedureVoid(sql, new
{
CacheTableStructXml = xmlString
});
return(result);
}