c# - Linq to SQL query to find partial duplicates -

-

i have looked @ lots of questions regarding linq sql , duplicates couldn't find leads me in right direction situation.

i have view want query return rows have same columna different columnb.

myview

  • id
  • columna
  • columnb

i can values of columna following t-sql query...

select a.columna, count(*)  (     select     b.columna, b.columnb     myview b     group b.columna, b.columnb ) group a.columna having count(*) > 1

..but translate linq sql , return id column well, if possible.

any appreciated.

nb. asp.net 4.0, c#, linq sql, sql server in use.

updated

sample data:

id, columna, columnb 1, aaa, a100 2, aaa, a100 3, aaa, b200 4, bbb, c300 5, bbb, c300

desired result:

id, columna, columnb 1, aaa, a100 2, aaa, a100 3, aaa, b200

(as column same, columnb different. id 4 , 5 not returned columnb values same.)

updated 2

somehow created following query part of wanted return columna value. improvements or suggestions on getting id appreciated.

list<string> duplicates = (from in                                (from b in dc.mytables                                 group b new { b.columna, b.columnb } c                                 select new                                 {                                     columna = c.key.columna,                                     columnb = c.key.columnb                                 })                            group a.columna d                            d.count() > 1                            select d.key).tolist();

doing sql tricky because asking have list of id's subgroup showing 1 column each value of a. not relational. accomplished using famous xml trick create concatenated string id values.

however in linq asking easy, because not limited flat row. can generate result first value string, , second list example. can generate result each unique columna field 1 , field 2 list of id's. can done using groupby into. take @ linq documentation or examples , should have no problem adapting data.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more