window.ENTITIES={'/api/snippets/cs/c%23%20-%20updating%20data%20in%20database%20using%20linq%20to%20sql':[{"result":true,"message":null,"batch":{"type":"cs","name":"c# - updating data in database using linq to sql","items":[{"id":"j4aAq1","type":"cs","name":"C# - updating data in database using LINQ to SQL","content":"// -----------------------------------------------------------\n// Program.cs file:\n// -----------------------------------------------------------\n\nusing System.Linq;\nusing System.Data.Linq;\n\npublic class Program\n{\n    public static void Main()\n    {\n        string connectionString = @\"Data Source=localhost\\SQLEXPRESS;Initial Catalog=projectdb;Integrated Security=True\";\n\n        using (DataContext dataContext = new DataContext(connectionString))\n        {\n            Table<UserEntity> users = dataContext.GetTable<UserEntity>();\n\n            UserEntity user = users.SingleOrDefault(u => u.Id == 1);  // tries to find user with id == 1\n\n            if (user != null)\n            {\n                user.Name = \"New-Name\";       // sets new name for the user\n\n                dataContext.SubmitChanges();  // saves changes in the database\n            }\n        }\n    }\n}\n\n\n// -----------------------------------------------------------\n// UserEntity.cs file:\n// -----------------------------------------------------------\n\nusing System;\nusing System.Data.Linq.Mapping;\n\n[Table(Name = \"Users\")]\npublic class UserEntity\n{\n    [Column(IsPrimaryKey = true, Name = \"Id\", IsDbGenerated = true)]\n    public long Id { get; set; }\n\n    [Column(Name = \"Name\")]\n    public string Name { get; set; }\n\n    [Column(Name = \"Role\")]\n    public string Role { get; set; } // ADMIN, MODERATOR, TEACHER, STUDENT\n\n    [Column(Name = \"CreatedAt\")]\n    public DateTime? CreatedAt { get; set; }\n\n    [Column(Name = \"RemovedAt\")]\n    public DateTime? RemovedAt { get; set; }\n}\n\n\n// -----------------------------------------------------------\n// Data base preparation:\n// -----------------------------------------------------------\n\n/*\n\n1. Create `projectdb` database\n\n2. Create `Users` table using:\n\n    USE [projectdb]\n    GO\n\n    CREATE TABLE [dbo].[Users] (\n        [Id] BIGINT IDENTITY(1,1) NOT NULL,\n        [Name] NCHAR(50) NOT NULL,\n        [Role] NCHAR(20) NOT NULL,\n        [CreatedAt] DATETIME NOT NULL,\n        [RemovedAt] DATETIME,\n        PRIMARY KEY ([Id])\n    );\n\n    GO\n\n    INSERT INTO [dbo].[Users]\n               ([Id], [Name], [Role], [CreatedAt], [RemovedAt])\n         VALUES\n               (1, 'Jan',    'ADMIN',     CURRENT_TIMESTAMP, null),\n               (2, 'Tomasz', 'MODERATOR', CURRENT_TIMESTAMP, null),\n               (3, 'Marek',  'STUDENT',   CURRENT_TIMESTAMP, null);\n\n    GO\n\n*/","source":"","author":{"id":"9oAE8o","name":"Lilly-Grace-Greig","avatar":"1629131828804__9oAE8o__w40px_h40px.jpg","points":571,"role":"BASIC"},"creationTime":1652497585000,"updateTime":1652711234000,"removalTime":null}]}}]};