LINQ OrderBy Name ThenBy ChildrenCollection.Name

Is there any way in LINQ to do an OrderBy and then do a ThenBy with the ThenBy using the children of the parent object to do the secondary ordering? _repository.GetActiveDepartmentGroupsWithDepartments().OrderBy(c => c.DepartmentGroupName).ThenBy(c => c.Departments.OrderBy(d => d.DepartmentName)) In the above case, c.Departments is an EntityCollection. BTW: When I try the above and t

LINQ OrderBy名称ThenBy ChildrenCollection.Name

有没有什么办法在LINQ做OrderBy,然后用ThenBy做一个ThenBy使用父对象的子对象进行二级排序? _repository.GetActiveDepartmentGroupsWithDepartments().OrderBy(c => c.DepartmentGroupName).ThenBy(c => c.Departments.OrderBy(d => d.DepartmentName)) 在上面的例子中,c.Departments是一个EntityCollection。 顺便说一句:当我尝试上述,然后做一个ToList(),我得到这个错误: DbSortClause expressions must

IntelliSense in custom COM classes in VBA

Is there a way to get IntelliSense in own built COM classes in VBA? Eg in the example below I would like to get "Number" showing up, whenever I press on the dot (or ctrl+space for shortcut): I suppose, if this is somehow resolved, I would also get some info concerning the public functions of the objects here: Thus, what are the suggestions? Suggestion 1 : Result - did not work

VBA中自定义COM类中的智能感知

有没有办法在VBA中的自己构建的COM类中获得IntelliSense? 例如,在下面的例子中,我想要显示“数字”,只要按下点(或ctrl +空格键)即可: 我想,如果这个问题得到了解决,我也会在这里得到关于这些对象的公共职能的一些信息: 因此,有什么建议? 建议1 : 结果 - 没有工作。 结果:这对我很有用(代码主要来自@dee):https://github.com/Vitosh/C-Sharp-Stuff/tree/master/IntSense 简单的例子可能是这样的。

How should I write this Entity Framework query?

I have two tables, Product and ProductCategories. A product can only have one category type. I need to query the database and find the product category for the given ProductID. The Product table has a column called ProductCategoryID, and the primary key of ProductCategories is ProductCatrgoryID. This is what I've tried so far but I get: Models.Product does not contain a definition for "P

我应该如何编写这个实体框架查询?

我有两个表,Product和ProductCategories。 产品只能有一个类别类型。 我需要查询数据库并查找给定ProductID的产品类别。 Product表中有一个名为ProductCategoryID的列,ProductCategories的主键是ProductCatrgoryID。 这是我迄今为止所尝试的,但我得到: Models.Product does not contain a definition for "ProductID" 代码: public ProductCategory GetProductCategory(int id) { var products = db.

Best practice to make a multi language application in C#/WinForms?

I've been looking into making applications suitable for multiple languages in C# since I need to work on a small project where this is the case. I have found basically two ways to do this: Set a form's Localizable property to true, set the Language property, fill all the labels and such, and you're 'done'. The major drawback I see in this is: how to make other stuff which

在C#/ WinForms中制作多语言应用程序的最佳实践?

我一直在考虑在C#中使用适合多种语言的应用程序,因为我需要在这种情况下处理一个小项目。 我发现基本上有两种方法可以做到这一点: 将表单的Localizable属性设置为true,设置Language属性,填充所有标签等,然后您就完成了。 我在这里看到的主要缺点是:如何制作不属于表单的多种语言(例如,弹出式窗口,日志文件或窗口等)的其他内容。 创建一个资源文件,例如'Lang.en-us.resx',每种语言一个,例如'Lang

One to one optional relationship using Entity Framework Fluent API

We want to use one to one optional relationship using Entity Framework Code First. We have two entities. public class PIIUser { public int Id { get; set; } public int? LoyaltyUserDetailId { get; set; } public LoyaltyUserDetail LoyaltyUserDetail { get; set; } } public class LoyaltyUserDetail { public int Id { get; set; } public double? AvailablePoints { get; set; } pub

使用Entity Framework Fluent API进行一对一的可选关系

我们希望使用实体框架代码优先使用一对一的可选关系。 我们有两个实体。 public class PIIUser { public int Id { get; set; } public int? LoyaltyUserDetailId { get; set; } public LoyaltyUserDetail LoyaltyUserDetail { get; set; } } public class LoyaltyUserDetail { public int Id { get; set; } public double? AvailablePoints { get; set; } public int PIIUserId { get; set; } p

Entity Framework: Problem associating entities with nullable field

I'm using Entity Framework, and I'm trying to associate an entity that was created from a database table with an entity that was created from a database view. Because Entity Framework is not able to infer the relationships between a database table and a view automatically, I'm using the entity designer to construct an "association" between the entities. However, if the for

实体框架:关联具有可空字段的实体的问题

我正在使用实体框架,并试图将从数据库表创建的实体与从数据库视图创建的实体相关联。 由于实体框架无法自动推断数据库表和视图之间的关系,因此我使用实体设计器来构造实体之间的“关联”。 但是,如果外键是一个nullalbe类型,我得到以下错误: 错误113:多重性在“用户视图”关系中的角色“公司”中无效。 由于依赖角色中的所有属性均可为空,因此主体角色的多重性必须为“0..1”。 在我的情况下,我在我的UsersView中有一个可

Entity Framework Database First many

I've created an Entity Framework model from the database. I have many-to-many relationship: User - UserRole - Role . EF created UserRole entity and UserRoles navigation property in the User entity and in Role entity, but I'd rather have Roles in User and Users in Role . Is that possible to be designed through the Model Designer? How can I configure manually many-to-many relationship

实体框架数据库第一多

我已经从数据库创建了一个实体框架模型。 我有多对多的关系: User - UserRole - Role 。 EF在User实体和Role实体中创建UserRole实体和UserRoles导航属性,但我宁愿在Roles中的User和Users Role 。 可以通过模型设计器来设计吗? 我怎样才能手动配置中间表与一个表的多对多关系? 如果UserRole表包含User和Role表的外键以外的列,则EF通常会创建中间模型。 所以如果你在UserRoles表中只有2列,那么两个FK到用户和角色表

Add Navigation Property Manually

I generated an Entity Framework Model (4.0) from my database. I did not design the database and do not have any control over the schema, but there are a few tables that do not have foreign key constraints defined, but there is an implicit relationship defined. For example: I have a table called People that has the following columns: GenderID RaceID There are tables for both Gender and Race

手动添加导航属性

我从我的数据库中生成了一个实体框架模型(4.0)。 我没有设计数据库,也没有对模式进行任何控制,但有几个表没有定义外键约束,但却有一个隐式关系定义。 例如: 我有一个名为People的表,它具有以下列:GenderID RaceID “性别”和“种族”都有表格,但People表格中没有外键。 当我导入模型时,它没有为这些关系添加导航属性。 我试图手动添加它,但从角色和角色被禁用。 我不知道如何自己添加关系。 我该怎么做呢?

converting string to enum

I've been using AutoMapper for a while now, and have come across a problem where I would need to map an object to another (shown below). Model: public Guid guid { get; set; } public string Status { get; set; } Which is transferred using the DTO: public Guid guid { get; set; } public Status Status { get; set; } The enum will contain: public enum Status { Example, AnotherExample

将字符串转换为枚举

我一直在使用AutoMapper一段时间,并遇到了一个问题,我需要将对象映射到另一个对象(如下所示)。 模型: public Guid guid { get; set; } public string Status { get; set; } 哪些是使用DTO传输的: public Guid guid { get; set; } public Status Status { get; set; } 枚举将包含: public enum Status { Example, AnotherExample, PossibleExample } 我设法让模型和DTO之间的转换工作,但是,转换是

IEnumerable and nested collections

I have a nested structure that follows this XML, with entities corresponding to the outer, middle & inner objects. <MyXml> <OuterObject> <OuterObjectID>123</OuterObjectID> <OuterObjectName>Out1</OuterObjectName> <MiddleObjectList> <MiddleObject> <MiddleObjectID>456</MiddleObjectID> <MiddleObjec

IEnumerable和嵌套集合

我有一个遵循这个XML的嵌套结构,实体对应于外部,中间和内部对象。 <MyXml> <OuterObject> <OuterObjectID>123</OuterObjectID> <OuterObjectName>Out1</OuterObjectName> <MiddleObjectList> <MiddleObject> <MiddleObjectID>456</MiddleObjectID> <MiddleObjectName>Middle1</MiddleObjectName> <K