Using entity framework, "order by Col1, Col2."

Adding existing entities to a collection on a newly built object using the entity framework

"Attach" is not allowed because you haven't saved the order yet. Calling "Add" tells Entity Framework that you want to insert a new contact. So you are left with only one option. You need to load the contact....Here's the fastest way to do that:...OrderDetails context = new OrderDetails(); Contact contact = context.GetObjectByKey(new EntityKey("Ord...

In entity framework, how do I sort by column with null values last?

I don't know if there's some switch somewhere that you can flip. Otherwise, the straight forward approach would probably be something along the lines of... using (var context = new DomainEntities()) { var FirstPart = context.Users.Where(u => u.LastName != null); var SecondPart = context.Users.Where(u => u.LastName == null); ...

LINQ order a collection of objects by date in descending order

Since you are describing the format of the date, I suppose that the datatype of the ...DateCreated... property is ...string.... If it is then you could do:....OrderByDescending(d => Convert.ToDateTime(d.DateCreated)).Take(10) ...Also, your ...Distinct()... will not have much effect if you don't specify your own equality to compare.

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

You should enable the Auditor...var auditConfiguration = AuditConfiguration.Default; auditConfiguration.IncludeRelationships = true; auditConfiguration.LoadRelationships = true; auditConfiguration.DefaultAuditable = true; ...just add it to place where your app is initialized, Global.asax.cs for example...edited...Far as I know you can't get old val...

Prevent Entity Framework adding ORDER BY when using Include

Apparently, it's something that EF does internally to ease the creation of resulting objects afterwards. You can't remove the ...order by... instruction.

Using expression trees to create a custom order by in linq to entities

Your code tries to create something like ...Queryable.OrderBy(queryableData.Expression, ExtValue105 => ExtValue105).... I have no idea why would you expect that to work....If I understand your question correctly, you need to dynamically create an expression like ...attribute => attribute.ExtValue105... and then you can use that to call ...OrderBy()...

Entity framework composite primary key - how to get order of columns

Try this:... var adapter = (IObjectContextAdapter)db; var objectContext = adapter.ObjectContext; var objectSet = objectContext.CreateObjectSet<SomeEntity>(); var entitySet = objectSet.EntitySet; var keyNames = entitySet.ElementType.KeyMembers .Select(e => e.Name).ToList(); ...If you want to find the auto ...

Entity Framework 6 inverting column order for composite foreign keys

You need to change the order of ...Beta... foreign key columns:...public class Beta { [Key, Column(Order = 1)] public string Beta_1 { get; set; } [Key, Column(Order = 3), ForeignKey("Alpha")] public string Alpha_2 { get; set; } [Required, ForeignKey("Alpha"), Column(Order = 2)] public string Alpha_1 { get; set; } public...

What logic determines the insert order of Entity Framework 6

You could order it before using the Add function and then use the save? Would it help/have your tried this?

LINQ to SQL - order by, group by and order by each group with skip and take

Just re-index your list results and remove the index before returning....var query = grades.GroupBy(student => student.Name) .Select(group => new { Name = group.Key, Students = group.OrderByDescending(x => x.Grade) }) .OrderBy(group => group.Students.FirstOrDefault().Grade) ...