online sql to linq generator

1Have you tried Linqer http://www.sqltolinq.com
2
3An SQL-> LINQ converter..
4
5Or LINQPad http://www.linqpad.net/

1select g.GroupId , g.GroupName, m.Title, p.ProjectId, p.BudgetEstimated, p.BudgetPlanned, p.BudgetConfirmed
2from Groups g Join Menu m
3on g.GroupId = m.GroupId
4Join ProjectBudgets p 
5on  p.ProjectId = '7BD2AA0C-6D78-48E3-9758-168135B7116B'

1SELECT * FROM TI_FLUXO_APROVACAO_LOG AS S 
2	WHERE LANCAMENTO NOT IN 
3	(SELECT LANCAMENTO FROM TI_FLUXO_APROVACAO_LOG 
4		WHERE ID_TI_FLUXO_APROVACAO_TI_STATUS_APROVACAO > 1)

1CREATE PROCEDURE [dbo].[GetContactType]  
2(  
3     @ContactTypeId UNIQUEIDENTIFIER = NULL  
4    ,@RowStatusId UNIQUEIDENTIFIER = '10000000-0000-0000-0000-000000000000'  
5    ,@IncludeAuditFields BIT = 0  
6    ,@ReturnCode INT = 0 OUTPUT  
7)  
8AS  
9BEGIN;  
10        SET NOCOUNT ON;  
11        SET @ReturnCode = 0;  
12        SELECT [dbo].[GetContactTypeXml]  
13               (@ContactTypeId  
14               ,@RowStatusId  
15               ,@IncludeAuditFields) AS [Result];  
16    RETURN @ReturnCode;  
17END;  
18