Contents tagged with TSQL
-
Functional Programming and LINQ Paradigm (2) Programming Paradigms and Functional Programming
Object-oriented programming and functional programming are programming paradigms. A programming paradigm is a fundamental style or approach of programming. Paradigms are not mutually exclusive. It is common for one programming language to support multiple paradigms, and C# is such a language.
-
Visual Studio Entity Data Model Wizard Not Responding
This post is for the issue that Entity Data Model Wizard becomes not responding. In Visual Studio 2015, when clicking the Finish button to create the entity data model from SQL Server 2014 SP! database, the wizard is frozen:
-
Attach SQL Server 2000 database to SQL Server 2014
In the MSDN introduction for LINQ to SQL, the Northwind sample database is used. It is a 15 years old database for SQL Server 2000. After downloading the database files, it cannot be attached to the latest SQL Server 2014 or 2016. trying to do so results an error:
-
Understanding LINQ to SQL (11) Performance
LINQ to SQL has a lot of great features like
- strong typing
- query compilation
- deferred execution
- declarative paradigm
etc., which are very productive. Of course, these cannot be free, and one price is the performance.
-
Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider
So far LINQ to SQL data CRUD (Creating / Retrieving / Updating / Deleting) has been explained. This post takes a deeper look at the internal implementation of LINQ to SQL query.
-
Understanding LINQ to SQL (9) Concurrent Conflict
Conflicts are very common when concurrently accessing the same data.
Conflicts in concurrent data access
The following code demonstrates the concurrent conflict scenario:
-
Understanding LINQ to SQL (8) Transaction
Database data Changing cannot be talked about without transactions.
Implementing TRANSACTION (BEGIN / COMMIT / ROLLBACK)
The previous post has shown that, when invoking SubmitChanges(), the translated SQL (INSERT / UPDATE / DELETE) are always executed within a TRANSACTION.
Internally, DataContext.SubmitChanges() invokes DataContext.SubmitChanges(ConflictMode.FailOnFirstConflict). The latter is implemented like this:
-
Where Is Transaction Events In SQL Server Profiler?
SQL Server Profiler does not monitor transaction events by default.
After installing SQL Server, when creating a new trace, the default template is “Standard”:
-
Understanding LINQ to SQL (7) Data Changing
-
Understanding LINQ to SQL (6) Working With Deferred Execution
-
Understanding LINQ to SQL (5) Remote And Local Method Call
-
Understanding LINQ to SQL (4) Data Retrieving Via Query Methods
-
Understanding LINQ to SQL (3) Expression Tree
-
Introducing LINQ (3) Programming Paradigms
[LINQ via C#] - [Introducing LINQ]