Enabling In-Memory OLTP in new and existing databases To create a new database and enable In-Memory OLTP in it, you can use the following script: CREATE DATABASE DemoOLTPDB ON PRIMARY ( NAME = DemoOLTPDB_data, FILENAME = ‘D:dataDemoOLTPDB.mdf’, size=500MB ), FILEGROUP DemoOLTPDB_IMOLTP_FG CONTAINS MEMORY_OPTIMIZED_DATA ( NAME = DemoOLTPDB_FG_Container, FILENAME = ‘D:dataDemoOLTPDB_FG_Container’ ) LOG ON ( NAME = ExamBook762Ch3_IMOLTP_log, FILENAME = ‘D:dataDemoOLTPDB_log.ldf’,...
Author: Joydip Kanjilal
Exploring OLTP in SQL Server 2019 (Part 1)
SQL Server has for long been Microsoft’s flagship database product. It has emerged one of the most popular Relational Database Management Systems (RDBMS) available in recent times. To meet the demands of the businesses and enterprises, many features have been added to the newer versions of SQL Server such as the In-Memory OLTP Engine. Support for OLTP was first introduced...
Advanced Features in LINQ to SQL: Part 2
Advanced Features in LINQ to SQL: Part 2 In the preceding article in this series we explored deferred execution concepts in LINQ and how we can invoke stored procedures and functions using LINQ. In the concluding part of this series, we will examine the following points: ü Handling Data concurrencies Managing Transactions Handling Data Concurrencies Concurrency in database arises when...
Advanced Features in LINQ to SQL: Part 1
Advanced Features in LINQ to SQL: Part 1 In this series of articles, we will cover the following points: ü U Using Stored Procedures in LINQ to SQL Deferred execution in LINQ to SQL Calling SQL Functions Handling Data concurrencies Managing Transactions Using Stored Procedures in LINQ to SQL Stored procedure is a compiled set of SQL statements referred by...
Exploring LINQ to Objects
Exploring LINQ to Objects LINQ to Objects allows us to query objects or collections of objects in memory. We use LINQ to Objects in the Object Model or Object Layer of our application In this article, we will cover the following points: Generic collections in C# LINQing generic collections LINQing non generic collections Using LINQ with Reflection Generic Collections in...
Exploring LinqDataSource Control in ASP.NET – Part 2
Exploring LinqDataSource Control in ASP.NET – Part 2 Ever since the evolution of the .NET Framework, there were always attempts being made to simplify the data access. Although the data source controls in the earlier versions of the framework provided data access and retrieval operations, there were also certain complexities involved in using the controls. LinqDataSource has brought us a...
Exploring LinqDataSource Control in ASP.NET – Part 1
Exploring LinqDataSource Control in ASP.NET – Part 1 The LinqDataSource control is a new data source control introduced in ASP.NET 3.5 that allows you to bind LINQ models to data bound controls in your web applications. LinqDataSource control allows you to connect to data sources like SQL Server and in-memory collections with a minimal need custom coding required for building...
Working with LINQ to Entities
Working with LINQ to Entities The ADO.NET Entity Framework enables you to raise the level of abstraction by isolating your application’s relational model from the object model. Added to what a typical ORM provides, it enables identity resolution, chance tracking, entity inheritance, entity composition, etc. The Entity Data Model (commonly known as EDM) is the core of the Entity Framework....
A Bird’s Eye View of the LINQ Library – Part 1
A Bird’s Eye View of the LINQ Library – Part 1 In this series of articles we will explore the LINQ library. In this firrst part of this series of articles, we will cover the following points:- The System.Linq Namespace The System.Data.Linq Namespace Exceptions in the System.Data.Linq Namespace Enumerations in the System.Data.Linq Namespace Working with the LINQ Library The LINQ...
Applying LINQ over CSV files
Applying LINQ over CSV files In this article we will discuss how we can apply LINQ over CSV files. Validating column structure in CSV files A comma separated (CSV) file contains all data in text format. Accessing CSV files programmatically could prove a nightmare if the file does not have proper structure or if it fails to adhere the type...