Which is better: SQL or LINQ?

• mitxpress [TS] on 25 Sep 13 @ 05:45 PM #

  Do you have any idea that you want to share if which is better between SQL and LINQ?

• dragonslash on 25 Sep 13 @ 08:01 PM #

  they are not the same.
  
  SQL is used to access database, while LINQ is used to access data in .net (ADO.net).

• arthurjr07 on 26 Sep 13 @ 08:07 AM #

  i think ang ibig nya sabihin e.
  
  which better - manually handcraft mo yung SQL script sa DAL mo or use LINQ that will auto generate yung SQL script?
  
  
  para sakin yung manually handcrafted na SQL script pa rin. Kung i-open mo yung SQL Profiler, tapos monitor mo yung mga ni-gegenerate na sql ng LINQ meron ako nakikita na hindi optimize. Lalo na yung mga complex LINQ, hindi optimize e.
  
  Pag yung architect hindi ganun kagaling sa SQL, pag nagdesign ng application Entity framework ginagamit nun. Pero pag ang architect e well versed din sa SQL, asahan mo, alam mo na yun.

• cevar_blackwing on 26 Sep 13 @ 08:29 AM #

  For CRUD operations, use LINQ. Very beneficial for RAD or Agile.
  
  For Search, Reports, Transaction use embedded SQL in DAL but if you\'ve got time use stored proc for better separation of concerns and better reusability.

• arthurjr07 on 26 Sep 13 @ 08:41 AM #

  egg-sac-li

• alanis_junkie43 on 26 Sep 13 @ 09:01 AM #

  mas madali din ang support pag SQL kesa LINQ, esp. sa mga reports. Tama sila, mabagal kadalasan ang reports pag LINQ ginawa, may ilan na din kami ni convert na report to SP para bumilis.

• dragonslash on 27 Sep 13 @ 01:17 PM #

  which better - manually handcraft mo yung SQL script sa DAL mo or use LINQ that will auto generate yung SQL script?

  
  i see. thanks
  
  

  
  For CRUD operations, use LINQ. Very beneficial for RAD or Agile.
  
  For Search, Reports, Transaction use embedded SQL in DAL but if you\'ve got time use stored proc for better separation of concerns and better reusability.

  
  
  i agree with this one.

• kimerran on 27 Sep 13 @ 04:01 PM #

  baka he/she meant LINQ2SQL?
  
  saken naman if applicable, LINQ2SQL, kung di kaya sa LINQ2SQL, raw SQL.
  
  nakakaubos ng oras yung gagawa ka ng CRUD manually tapos minsan problema mo pa yung relationships. lahat yan given na kay LINQ2SQL.

• arthurjr07 on 28 Sep 13 @ 08:16 PM #

  nakakaubos ng oras yung gagawa ka ng CRUD manually tapos minsan problema mo pa yung relationships. lahat yan given na kay LINQ2SQL.

  
  
  code generator. isang click lang meron ka ng class para sa CRUD. pwede mo pa i-extend yung class kung meorn ka gusto idagdag na method for complex sql.

• Mabuting_tao on 30 Sep 13 @ 03:33 PM #

  gumagamit lang ako ng ORM kapag nagbigay sila ng tight deadline, pero kung hindi naman, the best sa akin ang Micro-ORMs since its \"Close to Metal\"

• kimerran on 01 Oct 13 @ 09:47 AM #

  @arthurjr07: sir pwede makahingi ng examples ng code generator na sinasabi nyo po?
  
  

  gumagamit lang ako ng ORM kapag nagbigay sila ng tight deadline, pero kung hindi naman, the best sa akin ang Micro-ORMs since its \"Close to Metal\"

  
  
  sir, ano example ng mga micro-ORMs?

• arthurjr07 on 01 Oct 13 @ 03:40 PM #

  codesmith yung ginamit nmin dati. kung gusto mo meron ko ginawa sarili kong DAL/Entity generator. email mo ko forward ko sayo.

• kimerran on 01 Oct 13 @ 03:59 PM #

  @arthurjr07: pm sent! thanks po

• Mabuting_tao on 02 Oct 13 @ 01:05 AM #

  @kimerran
  
  Dapper, OrmLite, Massive, PetaPoco and Simple.Data
  
  -- edited by Mabuting_tao on Oct 02 2013, 01:19 AM

• jigslene24 on 08 Jul 16 @ 02:14 PM #

  Manga sir pa turo naman pano mag install ng sql server gagamitin ko sana sa mini office namin thanks