English 中文(简体)
只见外国钥匙的选定条目
原标题:Select entries where only a Foreign Key is present for that ID

I have 4 SQL tables as follows.

  • Registration
  • Optional table 1 [RegistrationID Foreign Key]
  • Optional table 2 [RegistrationID Foreign Key]
  • Optional table 3 [RegistrationID Foreign Key]

基本上,登记包含所有这些任择表格的数据,但每个任择表格都通过外国钥匙持有不同的额外数据。

利用LINQ至QQ,选择与这一选择表有关的登记的最佳方式是什么?

Pseudo-code would be
select all registrations where an entry in table [x] exists

Appreciate your help
Marko

最佳回答

var results = from r in dc.Registration
              join o1 in dc.Optional1 on r.RegistrationID equals o1.RegistrationID
              select r;

只有在登记记录与任择表1的相关记录有关系时,才能归还登记记录。

问题回答

暂无回答




相关问题
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. ...

热门标签