using System.Collections.Generic;
using System.Data.SqlServerCe;
public class PeripheralDevice
public string Name {get;set;} public string PDType {get;set;} public class PeripheralFunction
public string PDeviceID {get;set;} public static void Main()
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf")) var list = new List<PeripheralDevice>();
for (int i = 0; i < 50; i++)
list.Add(new PeripheralDevice() { Name = "Bulk Insert", PDType = "PDType Name :" + i}); connection.BulkInsert(list);
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf")) var list = new List<PeripheralFunction>();
for (int i = 0; i < 50; i++)
list.Add(new PeripheralFunction() { PDeviceID = "PDeviceID : " + i}); connection.BulkInsert(list);
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf")) var peripheralDevices = connection.Query<PeripheralDevice>("Select * FROM PeripheralDevice").ToList(); var peripheralFunctions = connection.Query<PeripheralFunction>("Select * FROM PeripheralFunction").ToList(); foreach (var peripheralDevice in peripheralDevices)
Console.WriteLine("Customer Name = " + peripheralDevice.PDType); var oneRecord = peripheralDevices.Where<PeripheralDevice>(x => x.PDType == "PDeviceID : 1").FirstOrDefault();
oneRecord.PDType = "DeviceID : 9999";
