Frameworks Archives - {coding}Sight https://codingsight.com/category/languages-coding/frameworks/ Blog for SQL Server DBAs and Developers Tue, 29 Aug 2023 06:48:49 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Frameworks Archives - {coding}Sight https://codingsight.com/category/languages-coding/frameworks/ 32 32 Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer https://codingsight.com/spark-sql-the-most-important-tool-for-a-big-data-engineer/ Thu, 22 Sep 2022 08:44:00 +0000 http://codingsight.com/?p=19145 Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what exactly is Spark SQL? What are spark data frames? How can you learn using it? Let’s take a look at its functions, capabilities, and, more importantly, the results it can provide for you. Table of …

The post Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer appeared first on {coding}Sight.

]]> Entity Framework – Just a Few Clicks Away https://codingsight.com/entity-framework-tutorial-how-to-add-ef-to-your-net-project/ Wed, 09 Jun 2021 07:01:49 +0000 http://codingsight.com/?p=14529 Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on a higher level of abstraction without the need to worry about the database type or structure where the data is stored. The focus of this article will be to show and explain how easy it …

The post Entity Framework – Just a Few Clicks Away appeared first on {coding}Sight.

]]> Creation of Pandas DataFrame in Python with Examples https://codingsight.com/an-overview-of-dataframes-in-python/ Fri, 23 Apr 2021 12:00:16 +0000 http://codingsight.com/?p=12994 Python is a general-purpose language that can work with various types of data structures and solve data-related problems with the help of community-built libraries. One of such ways of handling data in Python is using DataFrames. In this article, we will discuss what the DataFrames structure is and how to how to create a DataFrame …

The post Creation of Pandas DataFrame in Python with Examples appeared first on {coding}Sight.

]]> ASP.NET vs. PHP: the Best Framework for Web Development https://codingsight.com/asp-net-vs-php-best-framework-for-web-development/ Thu, 14 Jan 2021 12:33:45 +0000 https://codingsight.com/?p=11537 The primary goal of web development teams is to deliver web applications with the best user experience, scalability, and sustainability. Hence, developers always look for the right technology stack to build with these goals. There are various web technologies stacks like PHP, .Net, Ruby on Rails, Java, or Python. PHP and .NET are the most …

The post ASP.NET vs. PHP: the Best Framework for Web Development appeared first on {coding}Sight.

]]> Generic Repository Pattern in Entity Framework https://codingsight.com/entity-framework-antipattern-repository/ https://codingsight.com/entity-framework-antipattern-repository/#comments Thu, 07 Sep 2017 05:52:59 +0000 http://codingsight.com/?p=2164 A Repository mediates between the domain and data mapping layers, acting like an in-memory domain object collection. Client objects construct query specifications declaratively and submit them to Repository for satisfaction. Entity Framework provides us with the actual implementation of the Repository patterns: DbSet<T> and UnitOfWork: DbContext. I often see colleagues using in projects their own …

The post Generic Repository Pattern in Entity Framework appeared first on {coding}Sight.

]]> https://codingsight.com/entity-framework-antipattern-repository/feed/ 2 Implementing OOP Inheritance in Classes that work with SQL and Entity Framework https://codingsight.com/implementing-oop-inheritance-in-classes-that-work-with-sql-and-ms-entity-framework/ Wed, 16 Aug 2017 10:49:21 +0000 http://codingsight.com/?p=2033 This article is about creating a data model that would nicely fit SQL and contain “proper” OOP inheritance. I must say that I encountered this problem at various times on different projects, and I solved it in different ways. The names of the approaches are taken from the terminology that has developed on the relevant …

The post Implementing OOP Inheritance in Classes that work with SQL and Entity Framework appeared first on {coding}Sight.

]]> Entity Framework: Improving Performance when Saving Data to Database https://codingsight.com/entity-framework-improving-performance-when-saving-data-to-database/ https://codingsight.com/entity-framework-improving-performance-when-saving-data-to-database/#comments Tue, 30 May 2017 11:26:46 +0000 http://codingsight.com/?p=1534 When adding or modifying a large number of records (10³ and more), the Entity Framework performance is far from perfect. The reasons are architectural peculiarities of the framework, and non-optimality of the generated SQL. Leaping ahead, I can reveal that saving data through a bypass of the context significantly minimizes the execution time. Contents Insert/Update …

The post Entity Framework: Improving Performance when Saving Data to Database appeared first on {coding}Sight.

]]> https://codingsight.com/entity-framework-improving-performance-when-saving-data-to-database/feed/ 4 Entity Framework 6: Extensions You Might Be Unaware Of https://codingsight.com/entity-framework-6-extensions-you-might-be-unaware-of/ https://codingsight.com/entity-framework-6-extensions-you-might-be-unaware-of/#comments Fri, 14 Apr 2017 07:05:03 +0000 http://codingsight.com/?p=1195 Entity Framework 6 was and still remains a ‘workhorse’ for data access incorporate. NET-based applications primarily because of their stability, low barrier of entry, and wide renown. Therefore, I hope this article will still be useful. Contents Database First without EDMX Working with detached graphs SQL modification Data caching beyond the boundaries of the DbContext …

The post Entity Framework 6: Extensions You Might Be Unaware Of appeared first on {coding}Sight.

]]> https://codingsight.com/entity-framework-6-extensions-you-might-be-unaware-of/feed/ 2 The origin of GetHashCode in .NET https://codingsight.com/the-origin-of-gethashcode-in-net/ https://codingsight.com/the-origin-of-gethashcode-in-net/#comments Mon, 13 Feb 2017 08:18:10 +0000 http://codingsight.com/?p=518 This article is devoted to the GetHashCode method and the GetHashCode implementation in the .NET Framework. The article also discusses the different behavior of the method for reference types and value types. The topic is quite interesting and any self-respecting .NET developer needs to know it. So let’s go! What’s stored in reference-type objects apart from their field? …

The post The origin of GetHashCode in .NET appeared first on {coding}Sight.

]]> https://codingsight.com/the-origin-of-gethashcode-in-net/feed/ 1 SQL Server Unit Testing with tSQLt Framework https://codingsight.com/sql-server-unit-testing-with-tsqlt-framework/ Tue, 17 Nov 2015 07:21:23 +0000 http://codingsight.com/?p=117 In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You can use tSQLt to create unit tests for SQL Server 2005 (service pack 2 required) and all further versions. The main convenience is that you do not need to switch between various tools to create code and …

The post SQL Server Unit Testing with tSQLt Framework appeared first on {coding}Sight.

]]>