Showing posts with the label Linq 2 Sql

Log exception to file in c# .net core application explained

In production environment when any bug gets reported at that time as developer wants to get the exception details of bug to resolve the issue on high priority.
In some case there might be situation where exception is not logged in table but developer wants to check the bug immediately. for that purpose we need to write the
exception details including stack trace of bug in file. To implement this easily i am going to demonstrate the implementation of custom logging in file as below.

First we need to construct the exception and logger method in custom logger class as shown below.

public class CustomLogger { public static List<string> ConstructExceptionDetails(Exception ex,string FunctionName) { return new List<string>() { $"{DateTime.Now} - {FunctionName}", $"Exception: {ex.Message}", $"StackTrace: {ex.StackTrace}", $"InnerException: {ex.InnerException?.…

All about the IEnumerable VS IQueryable in c#

In Linq or entity framework, we use IEnumerable and IQueryable for data manipulation or query data. IEnumerable is inherited by IQueryable, Hence IQueryable has all the features of IEnumerable and except this, it has its own features and benefits.

Both have its own importance to query data and data manipulation in different situations in the application. we can go through with both the features and take the advantage of both the features to boost the LINQ Query performance. As per the need of application at some stage IEnumerable is useful and some stage in the application IQueryable is useful. Lets discuss about its use and features now.

IEnumerable Features:

IEnumerable exists in System.Collections Namespace.IEnumerable can move forward only over a collection, it can’t move backward and between the items.IEnumerable is best to query data from in-memory collections like List, Array etc.While query data from database, IEnumerable execute select query on server side, load data in-memory o…

Get LINQ to SQL results into a DataTable in

Linq to sql is a microsofts powerful tool to develop critical application faster.In Linq to sql the query result is in Generic list of generic  ienumerable type.

 If you want result set in DataTable you need to convert this generic list result into datatable. To convert LINQ to SQL results into a DataTable use following Code

DataClassesDataContext dc=new DataClassesDataContext(); var results = dc.products.ToList(); DataTable dt = new DataTable(); List<product> lst = results; PropertyInfo[] props= typeof(product).GetProperties(); foreach (var prop in props) { dt.Columns.Add(prop.Name); } foreach (var item in lst) { var rowa = new object[props.Length]; for (int i = 0; i < props.Length; i++) { rowa[i] = props[i].GetValue(item, null); } dt.Rows.Add(rowa); } GridView1…