Hi I have a sql query like

SELECT IsoCode, SUM(credit)-SUM(Debit)as [Balance]
  FROM RegisterTransactions
  WHERE  IsoCode NOT IN ('Regular')
  GROUP BY IsoCode
  UNION
  SELECT 'Regular', TransferAmount
  FROM RegisterTransactions
  WHERE  IsoCode IN ('Regular')

I want to convert it to linq I am facing problem please help me

I think you need a different group, one for LINQ or SQL perhaps, this one is for Visio.

you might check this out

https://msdn.microsoft.com/en-us/library/bb399401.aspx

al

Hi,

This is the forum to discuss questions and feedback for Microsoft Visio, please post your question to the SQL forum

https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support