English 中文(简体)
发现用户跟随其他用户
原标题:find users that are following other users
  • 时间:2010-05-24 16:03:21
  •  标签:
  • c#
  • linq

我很想知道我如何处理这个问题。

I have a DB with a Users Table, and a Followers table. The Followers table contains 2 Columns "FollowerID" and "FollowedID" I have a 1 -> * relation in my datamodel between Users.ID -> Followers.FollowerID and Users.ID -> FollowedID

如何让一组用户了解特定用户?

I ll express what I m trying to achieve programatically I can get this far:

ctx.Followers.Where(f => f.FollowedID == CurrentUser.ID)

现在,我有一套跟踪器,由谁来跟踪目前的用户,我可以通过这一收集来检索,然后在每次收集之后增加用户,以收集继目前User之后的全美国ER收集,但是没有哪一种是穿甲的,或者说是路要这样做的。

非常感谢

图十

最佳回答
ctx.Followers.Where(f => f.FollowedID == CurrentUser.UserId)
             .Select(f => f.FollowerUser).Distinct()

如果您拥有一个实体(例如FollewerUser),你就可以利用这个实体,使所有用户都了解某个特定身份。

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签