¡@
c# Programming Glossary: myentityHow to query flags stored as enum in NHibernate http://stackoverflow.com/questions/2805661/how-to-query-flags-stored-as-enum-in-nhibernate HQL is easy var matching session.CreateQuery @ from MyEntity where FlagsProperty flag flag .SetParameter flag MyEnum.FlagValue..
Does Entity Framework 4 Code First have support for identity generators like NHibernate? http://stackoverflow.com/questions/5275306/does-entity-framework-4-code-first-have-support-for-identity-generators-like-nhi USE IN REAL SCENARIOS private static int i 0 public DbSet MyEntity MyEntities get private set public Context base connection MyEntities.. private set public Context base connection MyEntities Set MyEntity protected override void OnModelCreating ModelBuilder modelBuilder.. base.OnModelCreating modelBuilder modelBuilder.Entity MyEntity .HasKey e e.Id Turn off autogeneration in database modelBuilder.Entity..
Linq to Entities, random order http://stackoverflow.com/questions/654906/linq-to-entities-random-order Framework stuff and LINQ to Entities. air code IEnumerable MyEntity results from en in context.MyEntity where en.type myTypeVar.. air code IEnumerable MyEntity results from en in context.MyEntity where en.type myTypeVar orderby select en Thanks Edit.. Random return new Guid And using this query IEnumerable MyEntity results from en in context.MyEntity where en.type myTypeVar..
Entity Framework 4.1. Most efficient way to get multiple entities by primary key? http://stackoverflow.com/questions/8107439/entity-framework-4-1-most-efficient-way-to-get-multiple-entities-by-primary-key watch.ElapsedMilliseconds Test 1 var result context.Set MyEntity .Where e ids.Contains e.ID .ToList Result msec 85.5 sec Test.. .ToList Result msec 85.5 sec Test 2 var result context.Set MyEntity .AsNoTracking .Where e ids.Contains e.ID .ToList Result msec.. . MyEntities WHERE ID IN 0 values var result context.Set MyEntity .SqlQuery sql .ToList Result msec 5.1 sec Test 4 same as Test..
EF Distinct (IEqualityComparer) Error http://stackoverflow.com/questions/1010944/ef-distinct-iequalitycomparer-error public class FooClass public void FooMethod using var myEntity new MyEntity var result myEntity.MyDomainEntity.Where myDomainEntity.. void FooMethod using var myEntity new MyEntity var result myEntity.MyDomainEntity.Where myDomainEntity myDomainEntity.MySpecialID.. to turn IQueryable T into IEnumerable T var result myEntity.MyDomainEntity .Where myDomainEntity myDomainEntity.MySpecialID..
User-defined conversion operator from base class http://stackoverflow.com/questions/3401084/user-defined-conversion-operator-from-base-class Without it the compiler will allow me to do Method B Body myEntity ... However at runtime I will get an exception saying this cast..
Update Row if it Exists Else Insert Logic with Entity Framework http://stackoverflow.com/questions/5557829/update-row-if-it-exists-else-insert-logic-with-entity-framework use if context.ObjectStateManager.GetObjectStateEntry myEntity .State EntityState.Detached context.MyEntities.AddObject myEntity.. .State EntityState.Detached context.MyEntities.AddObject myEntity Attached object tracks modifications automatically context.SaveChanges.. about the object's key you can use something like this if myEntity.Id 0 context.MyEntities.Attach myEntity context.ObjectStateManager.ChangeObjectState..
|
