Linq.Binary(SQL Image Data Type) Type to File Stream
I got a column with Data Type of Image in SQL Server. What I would like to do is to omit this data to a FileStream or to a file. I tried to read the data…
-
-
SQL Methods in LINQ
I’m trying to implement DateDiff in LINQ. I would like to get all records with the same date and ignoring the timestamp. Here is my code snippet which doesn’t work public int tblExpReceiptFileUniqueID(string chCreateStaffCode, string vcFileName,…
-
Paging in Order BY using LINQ
This is a simple way of doing the paging in LINQ. If I do the paging before the ORDER BY then it will give me different result set. The paging is should be after the ORDER…
-
Simple LINQ Tutorial
I’ve started learning about LINQ because I need to keep up to date with the latest technology out there. I’ve created a simple Business Layer which interact directly with Linq to SQL(DBML). It includes Insert, Update,…