public void NullReferenceWhenInsertingPk()
 {
     using (testEntities1 ctx = new testEntities1())
     {
         gamingplatform gp = new gamingplatform()
         {
             Name = "PlayStation2"
         };
         ctx.AddTogamingplatform(gp);
         ctx.SaveChanges();
     }
 }
        public void TakeWithView()
        {
            using (testEntities1 ctx = new testEntities1())
            {
                var    q   = ctx.vivideogametitle.Take(10);
                string sql = q.ToTraceString();
                st.CheckSql(sql, SQLSyntax.TakeWithView);
#if DEBUG
                Debug.WriteLine(sql);
#endif
                foreach (var row in q)
                {
                    //
                }
            }
        }
Ejemplo n.º 3
0
        public void JoinsAndConcatsWithComposedKeys()
        {
            using (testEntities1 ctx = new testEntities1())
            {
                IQueryable <gamingplatform> l2 = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
                IQueryable <gamingplatform> l  = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
                var l4 = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
                l = l.Concat(l4);
                l = l.Concat(ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10).Distinct());

                IQueryable <gamingplatform>    q  = (from i in l join i2 in l2 on i.Id equals i2.Id select i);
                IQueryable <videogameplatform> l3 = from t1 in q
                                                    join t2 in q.SelectMany(p => p.videogameplatform)
                                                    on t1.Id equals t2.IdGamingPlatform
                                                    select t2;
                videogameplatform pu = null;

                pu = l3.FirstOrDefault();
            }
        }
Ejemplo n.º 4
0
    public void JoinsAndConcatsWithComposedKeys()
    {
      using (testEntities1 ctx = new testEntities1())
      {
        IQueryable<gamingplatform> l2 = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
        IQueryable<gamingplatform> l = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
        var l4 = ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10);
        l = l.Concat(l4);
        l = l.Concat(ctx.gamingplatform.Where(p => string.IsNullOrEmpty(p.Name)).Take(10).Distinct());

        IQueryable<gamingplatform> q = (from i in l join i2 in l2 on i.Id equals i2.Id select i);
        IQueryable<videogameplatform> l3 = from t1 in q
                                           join t2 in q.SelectMany(p => p.videogameplatform)
                                               on t1.Id equals t2.IdGamingPlatform
                                           select t2;
        videogameplatform pu = null;

        pu = l3.FirstOrDefault();
      }
    }