SQL - transformar consultas SQL a consultas LinQ to SQL792 visitas 0 respuesta
Hola, estoy comenzando a trabajar con Linq to Sql y no sé hacer ni siquiera consultas simples, descargué de http://www.sqltolinq.com/ el linqer (hace transformaciones de Sql a Linq to Sql) pero da un error durante la instalación, quería saber si alguien podía transformarme algunas de las consultas SQL que muestro a continuación, no tienen que ser todas, si muestro tantas es sólo porque quería tener un ejemplo de cada comando, supongamos que tengo las tablas Store_Information ((string)store_name, (decimal)Sales, (datetime)Date) y Geography ((string)store_region, (string)store_name) y la clase ReportesDataContext, estas son las consultas SQL: 1 - select SELECT store_name FROM Store_Information 2 - distint SELECT DISTINCT store_name FROM Store_Information 3 - where SELECT store_name FROM Store_Information WHERE Sales > 1000 4 - and / or SELECT store_name FROM Store_Information WHERE Sales > 1000 OR (Sales < 500 AND Sales > 275) 5 - in SELECT * FROM Store_Information WHERE store_name IN ('Los Angeles', 'San Diego') 6 - between SELECT * FROM Store_Information WHERE Date BETWEEN '06-Jan-1999' AND '10-Jan-1999' 7 - like SELECT * FROM Store_Information WHERE store_name LIKE '%AN%' 8 - order by SELECT store_name, Sales, Date FROM Store_Information ORDER BY Sales DESC 9 - funciones SELECT SUM(Sales) FROM Store_Information SELECT MIN(Sales) FROM Store_Information SELECT MAX(Sales) FROM Store_Information SELECT COUNT(Sales) FROM Store_Information SELECT AVG(Sales) FROM Store_Information 10 - group by SELECT store_name, SUM(Sales) FROM Store_Information GROUP BY store_name 11 - count SELECT COUNT(store_name) FROM Store_Information 12 - having SELECT store_name, SUM(sales) FROM Store_Information GROUP BY store_name HAVING SUM(sales) > 1500 13 - alias SELECT A1.store_name Store, SUM(A1.Sales) "Total Sales" FROM Store_Information A1 GROUP BY A1.store_name 14 - join SELECT A1.region_name REGION, SUM(A2.Sales) SALES FROM Geography A1, Store_Information A2 WHERE A1.store_name = A2.store_name GROUP BY A1.region_name 15 - outer join SELECT A1.store_name, SUM(A2.Sales) SALES FROM Geography A1, Store_Information A2 WHERE A1.store_name = A2.store_name (+) GROUP BY A1.store_name 16 - concatenar SELECT region_name + ' ' + store_name FROM Geography WHERE store_name = 'Boston'; 17 - trim SELECT TRIM(' Sample '); SELECT LTRIM(' Sample '); SELECT RTRIM(' Sample '); Muchas Gracias de antemano. También te puede interesar... problema al crear trigger Ayuda con query |