Need help on LINQ Query C#

Question

Dear All, I am new to LINQ, I wrote a following code using C#, but I need to rewrite using LINQ, so could you please let me know , how can I rewrite the same. Basicaly I want to achive for all the 0th position in the array I need to set NULL value, for the certin property. Here - OrganizationList is an array. if (OrganizationList.Count > 0) { if (OrganizationList[0].OrganizationLevel == 0) { OrganizationList[0].NetworkParticipation = null; OrganizationList[0].ApprovalPolicyID = null; OrganizationList[0].LastUpdateDate = null; } } Please help me

Jaish Mathews · Answer

Using LINQ, you can assign null value through below steps. //Take 1st Organization from a list and then assigning null Organization firstOrg = organizationList.Where((org, index) => index is 0).First(); firstOrg.ApprovalPolicyID = null; firstOrg.LastUpdateDate= null; firstOrg.NetworkParticipation = null; I tried with a sample class and it worked. Also please declare nullable property types under "Organization" class when property needs to make null. Below is full code. public class Organization { public string NetworkParticipation { get ; set ; } public int ? ApprovalPolicyID { get ; set ; } public DateTime? LastUpdateDate { get ; set ; } } static void Main( string [] args) { List organizationList = new List(); organizationList.Add( new Organization { ApprovalPolicyID = 100, LastUpdateDate = DateTime.Now.AddDays(-5), NetworkParticipation = "100" }); organizationList.Add( new Organization { ApprovalPolicyID = 200, LastUpdateDate = DateTime.Now.AddDays(-3), NetworkParticipation = "200" }); organizationList.Add( new Organization { ApprovalPolicyID = 300, LastUpdateDate = DateTime.Now.AddDays(-1), NetworkParticipation = "300" }); Organization firstOrg = organizationList.Where((org, index) => index is 0).First(); firstOrg.ApprovalPolicyID = null ; firstOrg.LastUpdateDate= null ; firstOrg.NetworkParticipation = null ; Console.ReadLine(); }

Tajmara · Answer

Hi, that if condition is working for u. inside the condition its working or skip the condition for debugging mode. if (OrganizationList[0].OrganizationLevel == 0) => true or false u r getting. { } u try to check null condition also. OrganizationList[0].OrganizationLevel == null also knw. thanks.

Uzma Khan · Answer

Kumar AU, Please provide OrganizationList . Here you can also modify your code like if (OrganizationList.Count > 0 && OrganizationList[0].OrganizationLevel == 0) { OrganizationList[0].NetworkParticipation = null; OrganizationList[0].ApprovalPolicyID = null; OrganizationList[0].LastUpdateDate = null; }

Kumar AU · Answer

Hi Jaish, Thanks for your response, Yes OrganizationList is the collection, which contains 10 property, in that I need to make 0th level/position (Yes 1st element) for these property NULL values - NetworkParticipation,ApprovalPolicyID and LastUpdateDate Please help me

Jaish Mathews · Answer

But the quote "0th position in the array?" There isn't any array in your code. You meant by first element in the "OrganizationList" collection?

Need help on LINQ Query C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)