Need help on LINQ Query C#

Kumar AU

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Accepted 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();

}
+1
Tajmara8y ago
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.
+1
Uzma Khan8y ago
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;
}
+1
Kumar AU8y ago
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
+1
Jaish Mathews8y ago
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?
+1