コード例 #1
0
ファイル: mphDb.cs プロジェクト: richiebful/mphdict
        public mphODInfo getObj()
        {
            var       context = getContext();
            mphODInfo dataObj = new mphODInfo();

            try
            {
                //var data = (from c in context.noms.Include(acc=>acc.accents_class).Include(part=>part.parts).Include(indent => indent.indents).Include(minoracc => minoracc.minor_acc).Include(flex=>flex.indents.flexes) where c.isactive == true && c.isdel == false orderby c.digit, c.field2, c.reestr select c);
                var data = (from c in context.words_list.AsNoTracking() where c.isdel == false orderby c.digit, c.field2, c.reestr select c);
                dataObj.words_list    = data./*Take(5).*/ ToArray();
                dataObj.types         = (from c in context.indents.AsNoTracking() orderby c.type select c).ToArray();                            // context.Local(context.indents).OrderBy(x => x.type).ToArray();
                dataObj.grs           = (from c in context.grs.AsNoTracking() orderby c.id select c).ToArray();                                  // context.Local(context.grs).OrderBy(x => x.id).ToArray();
                dataObj.accents       = (from c in context.accent.AsNoTracking() orderby c.accent_type, c.gram select c)./*Take(5).*/ ToArray(); // context.Local(context.accent).OrderBy(x => x.accent_type).ThenBy(y=>y.gram).ToArray();
                dataObj.parts         = (from c in context.parts.AsNoTracking() orderby c.id select c).ToArray();                                // context.Local(context.parts).OrderBy(x => x.id).ToArray();
                dataObj.accents_class = (from c in context.accents_class.AsNoTracking() orderby c.id select c).ToArray();                        // context.Local(context.accents_class).OrderBy(x => x.id).ToArray();
                dataObj.minor_accs    = (from c in context.minor_acc.AsNoTracking() orderby c.nom_old select c)./*Take(5).*/ ToArray();          // context.Local(context.minor_acc).OrderBy(x => x.nom_old).ToArray();
                //dataObj.allangs = (from c in context.allangs.AsNoTracking() where c.id_lang == 1058 orderby c.full_lang select c).ToArray(); // context.allangs.OrderBy(x => x.full_lang).ToArray();
                dataObj.lang        = (from c in context.lang.AsNoTracking() select c).ToArray();                                                // context.allangs.OrderBy(x => x.full_lang).ToArray();
                dataObj.alphadigits = (from c in context.alphadigits.AsNoTracking() orderby c.lang, c.digit, c.ls select c).ToArray();           // context.Local(context.alphadigits).OrderBy(x => x.lang).ThenBy(y=>y.digit).ThenBy(z => z.ls).ToArray();
                return(dataObj);
            }
            catch (Exception ex)
            {
                Logger.LogError(new EventId(0), ex, ex.Message);
                return(null);
            }
            finally
            {
                if ((db == null) && (context != null))
                {
                    context.Dispose();
                }
            }
        }
コード例 #2
0
ファイル: mphDb.cs プロジェクト: richiebful/mphdict
        public void copyFromObj(mphODInfo o)
        {
            var context = getContext();

            try
            {
                this.removeData();

                context.alphadigits.AddRange(o.alphadigits);
                context.SaveChanges();

                context.lang.AddRange(o.lang);
                context.SaveChanges();

                //for(int i=0;i< o.accents_class.Length;i++)
                //{
                //    context.accents_class.Add(o.accents_class[i]);
                //}
                //context.SaveChanges();
                //context.accents_class.AddRange(o.accents_class);
                //context.SaveChanges();

                //context.accent.AddRange(o.accents);
                //context.SaveChanges();

                //context.grs.AddRange(o.grs.Select(c=>new Models.morph.gr() { id=c.id, part_of_speech = c.part_of_speech }));
                //context.SaveChanges();

                //context.parts.AddRange(o.parts);
                //context.SaveChanges();

                //context.indents.AddRange(o.indents);
                //context.SaveChanges();

                //context.flexes.AddRange(o.flexes);
                //context.SaveChanges();

                //context.words_list.AddRange(o.words_list);
                //context.SaveChanges();

                //context.minor_acc.AddRange(o.minor_accs);
                //context.SaveChanges();
            }
            catch (Exception ex)
            {
                Logger.LogError(new EventId(0), ex, ex.Message);
            }
            finally
            {
                if ((db == null) && (context != null))
                {
                    context.Dispose();
                }
            }
        }