Wsrtjtyk

Creating a DataTable From a Linq Query
I use Ling to show my data on dataGridview and I have linq search funtion to search poeple. It's workin fine but not as Datatable do. I have to write the hole name before my serch function shoe me the name. I want to create Creat a DataTable From a Linq Query but I donät know how to do it.
Here is my code:

public void SerachdataEmp(string name)

{

    db = new EmployeeEntity();

    var result = (from u in db.Employee

    join d in db.Department on u.DepartmentId equals d.DepartmentId 

    where u.FirstName == name

    select new

    {                            

       FirstName = u.FirstName,

       LastName = u.LastNameName,

       DepartmentName = d.DepartmentName 

    }      

}).Tolist();

dataGridView1.DataSource = result;

I tried like this

(from u in db.Employee.AsEnumerable()

 join d in db.Department.AsEnumerable() on u.DepartmentId equals d.DepartmentId 

 where u.FirstName == searchEmployee



but then I don't know how to do. Thank you in advance!    

instead use query.ToList();

use

 query.CopyToDataTable();

I don't recommend this, and I don't believe your search issue is with not using a DataTable, but using these extensions you can convert your query answer into a DataTable - just put ToDataTable() in place of ToList().

public static class ExtensionMethods {

    // ***

    // *** IEnumerable<> Extensions

    // ***

    public static DataTable ToDataTable<T>(this IEnumerable<T> rows) {

        var dt = new DataTable();

        if (rows.Any()) {

            var rowType = typeof(T);

            var memberInfos = rowType.GetPropertiesOrFields();

            foreach (var info in memberInfos)

                dt.Columns.Add(new DataColumn(info.Name, info.GetMemberType()));



            foreach (var r in rows)

                dt.Rows.Add(memberInfos.Select(i => i.GetValue(r)).ToArray());

        }

        return dt;

    }



    // ***

    // *** MemberInfo Extensions

    // ***

    public static Type GetMemberType(this MemberInfo member) {

        switch (member) {

            case FieldInfo mfi:

                return mfi.FieldType;

            case PropertyInfo mpi:

                return mpi.PropertyType;

            case EventInfo mei:

                return mei.EventHandlerType;

            default:

                throw new ArgumentException("MemberInfo must be if type FieldInfo, PropertyInfo or EventInfo", nameof(member));

        }

    }



    public static object GetValue(this MemberInfo member, object srcObject) {

        switch (member) {

            case FieldInfo mfi:

                return mfi.GetValue(srcObject);

            case PropertyInfo mpi:

                return mpi.GetValue(srcObject);

            default:

                throw new ArgumentException("MemberInfo must be of type FieldInfo or PropertyInfo", nameof(member));

        }

    }



    // ***

    // *** Type Extensions

    // ***

    public static List<MemberInfo> GetPropertiesOrFields(this Type t, BindingFlags bf = BindingFlags.Public | BindingFlags.Instance) =>

        t.GetMembers(bf).Where(mi => mi.MemberType == MemberTypes.Field | mi.MemberType == MemberTypes.Property).ToList();

}