Compared to SQL, LINQ is simpler, tidier, and higher-level.
By using Linq we can query data in Collection,XML files,Entity,which is not possible with sql.
advantages of LINQ over SQl :
I can use any .NET debugger to debug the queries. With sprocs, you cannot easily debug the SQL and that experience is largely tied to your database vendor (MS SQL Server provides a query analyzer, but often that isn't enough).
it's easier to deploy a single assembly than to deploy a set of stored procedures in sql.Niranjan11, if this helps please login to Mark As Answer. | Alert Moderator