EF - Check Object Existence | C# Online Compiler

EF - Check Object Existence by ZZZ Projects

// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Extensions

using System;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
					
public class Program
{
	public static void Main()
	{
		// BulkInsert: INSERT all entities in the database.
		using (var context = new EntityContext())
		{
			context.BulkInsert(Data());
		}
		
		// Query data
		using (var context = new EntityContext())
		{
			if(context.Customers.Any(c => c.CustomerID == 1))
    		{
        		Console.WriteLine("Object exists");
    		} 
		}
	}
	
	public static List<Customer> Data() 
	{
		List<Customer>  list = new List<Customer>();
		
		for(int i = 0; i < 1000; i++)
		{
			list.Add(new Customer() { Name ="Customer_" + i});
		}
		
		return list;
	}

	public class EntityContext : DbContext
	{
		public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
		{

		}
		
		public DbSet<Customer> Customers { get; set; }
	}
	
	
	public class Customer
	{
		public int CustomerID { get; set; }
		public string Name { get; set; }
	}
}

​x
 
// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Extensions
​
using System;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
                    
public class Program
{
    public static void Main()
    {
        // BulkInsert: INSERT all entities in the database.
        using (var context = new EntityContext())
        {
            context.BulkInsert(Data());
        }
        
        // Query data
        using (var context = new EntityContext())
        {
            if(context.Customers.Any(c => c.CustomerID == 1))
            {
                Console.WriteLine("Object exists");
            } 
        }
    }
    
    public static List<Customer> Data() 
    {
        List<Customer>  list = new List<Customer>();
        
        for(int i = 0; i < 1000; i++)
        {
            list.Add(new Customer() { Name ="Customer_" + i});
        }
        
        return list;
    }
​
    public class EntityContext : DbContext
    {
        public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
        {
​
        }
        
        public DbSet<Customer> Customers { get; set; }
    }
    
    
    public class Customer
    {
        public int CustomerID { get; set; }
        public string Name { get; set; }
    }
}

Opened connection at 2/25/2025 8:05:53 PM +00:00
SELECT
    [Extent1].[CustomerID] AS [CustomerID],
    [Extent1].[Name] AS [Name]
    FROM [dbo].[Customers] AS [Extent1]
-- Executing at 2/25/2025 8:05:54 PM +00:00
-- Completed in 2 ms with result: SqlDataReader

Closed connection at 2/25/2025 8:05:54 PM +00:00
Customer Name: Customer_1
Opened connection at 2/25/2025 8:05:54 PM +00:00
SELECT
    [Extent1].[InvoiceID] AS [InvoiceID],
    [Extent1].[Date] AS [Date],
    [Extent1].[CustomerID] AS [CustomerID]
    FROM [dbo].[Invoices] AS [Extent1]
    WHERE [Extent1].[CustomerID] = @EntityKeyValue1
-- EntityKeyValue1: '1' (Type = Int32, IsNullable = false)
-- Executing at 2/25/2025 8:05:54 PM +00:00
-- Completed in 5 ms with result: SqlDataReader

Closed connection at 2/25/2025 8:05:54 PM +00:00
    Invoice Date: 5/3/2018 12:00:00 AM
    Invoice Date: 2/20/2025 8:05:53 PM
    Invoice Date: 2/22/2025 8:05:53 PM
Customer Name: Customer_2
Opened connection at 2/25/2025 8:05:54 PM +00:00
SELECT
    [Extent1].[InvoiceID] AS [InvoiceID],
    [Extent1].[Date] AS [Date],
    [Extent1].[CustomerID] AS [CustomerID]
    FROM [dbo].[Invoices] AS [Extent1]
    WHERE [Extent1].[CustomerID] = @EntityKeyValue1
-- EntityKeyValue1: '2' (Type = Int32, IsNullable = false)
-- Executing at 2/25/2025 8:05:54 PM +00:00
-- Completed in 1 ms with result: SqlDataReader

Closed connection at 2/25/2025 8:05:54 PM +00:00
    Invoice Date: 4/15/2018 12:00:00 AM
Customer Name: Customer_3
Opened connection at 2/25/2025 8:05:54 PM +00:00
SELECT
    [Extent1].[InvoiceID] AS [InvoiceID],
    [Extent1].[Date] AS [Date],
    [Extent1].[CustomerID] AS [CustomerID]
    FROM [dbo].[Invoices] AS [Extent1]
    WHERE [Extent1].[CustomerID] = @EntityKeyValue1
-- EntityKeyValue1: '3' (Type = Int32, IsNullable = false)
-- Executing at 2/25/2025 8:05:54 PM +00:00
-- Completed in 0 ms with result: SqlDataReader

Closed connection at 2/25/2025 8:05:54 PM +00:00
    Invoice Date: 2/20/2018 12:00:00 AM
    Invoice Date: 5/22/2018 12:00:00 AM

Cached Result
Last Run:	8:05:47 pm
Compile:	0.283s
Execute:	9.355s
Memory:	49.73Mb
CPU:	4.656s

View IL Code