C# (CSharp) PSsqmEntities.AddToCURRENCY_XREF примеры использования

Пример #1

        public static CURRENCY_XREF InsertRate(string currencyCode, int year, int month, double rate)
        {
            CURRENCY_XREF xref;

            using (PSsqmEntities entities = new PSsqmEntities())
            {
                try
                {
                    xref = (from x in entities.CURRENCY_XREF
                            where (x.EFF_YEAR == year && x.EFF_MONTH == month && x.CURRENCY_CODE == currencyCode)
                            select x).Single();
                }
                catch
                {
                    xref           = new CURRENCY_XREF();
                    xref.EFF_YEAR  = year;
                    xref.EFF_MONTH = month;
                    entities.AddToCURRENCY_XREF(xref);
                }

                xref.CURRENCY_CODE      = currencyCode;
                xref.BASE_CURRENCY_RATE = (decimal)rate;

                entities.SaveChanges();
            }

            return(xref);
        }