Data model Resources

Share

Related resources for Data model

Introduction to Power BI: A Beginner's Guide10/22/2024 9:31:36 AM. Power BI is a powerful business analytics tool from Microsoft designed for data visualization and sharing insights across organizations. This beginner-friendly guide covers its key components, includi
Creating an Entity Data Model (Entity Framework 4.0)10/1/2024 9:06:15 AM. The ADO.NET Entity Framework is a new data access platform from Microsoft for writing .NET applications. It is a set of technologies in ADO.NET that helps fill in the space between object-oriented.
How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
Using Business Objects As Models In MVC9/26/2024 7:15:50 AM. This approach enhances code reusability, maintainability, and separation of concerns by clearly defining the role of models in managing the application's core functionality.
Array of Structure and Structures with in a Structure9/13/2024 5:23:54 AM. Explore the concept of arrays of structures and structures within structures in data modeling. Understand how to manage complex data by nesting structures, utilizing multidimensional arrays, and creat
Create XML in .NET Core API and Send to Stored Procedure Using Dapper7/30/2024 10:43:10 AM. Learn how to create and send XML data to a stored procedure in a .NET Core Web API. This guide covers setting up a .NET Core Web API project, generating XML from data models, using Dapper for database
CQRS Simplified - Explained and Implemented7/30/2024 9:13:28 AM. CQRS (Command Query Responsibility Segregation) in .NET Core separates read and write operations for better scalability and performance. By using distinct models for commands and queries, it simplifie
Database First Approach in .NET Core7/25/2024 7:54:49 AM. Discover the Database First Approach in .NET Core with our comprehensive guide. Learn how to efficiently integrate databases into your application using Entity Framework Core, design robust data model
What is Microsoft Dataverse and how it works?7/19/2024 6:30:04 AM. Microsoft Dataverse, integral to the Power Platform, provides scalable data management with robust security and seamless integration capabilities. It simplifies data modeling, validation, and access f
Building RESTful APIs with ASP.NET Core7/16/2024 7:14:32 PM. In today's interconnected digital landscape, creating robust and efficient APIs is crucial for enabling seamless communication between applications. ASP.NET Core, the open-source framework from Mi
Python Data Classes: Reducing Boilerplate and Improving Readability7/9/2024 10:31:18 AM. Discover the advantages of Python data classes in this insightful article. Learn how they reduce boilerplate code and enhance readability, making your programming tasks more efficient.
Getting Started with ZooKeeper: A Beginner's Guide6/20/2024 8:57:57 AM. Learn the basics of Apache ZooKeeper, a distributed coordination service, including its architecture, installation, usage, and practical examples.
What Are Object-Oriented Databases And Their Advantages6/12/2024 10:23:20 AM. In this article, you will learn what object-oriented databases are what are their advantages.
Automate Placeholder Replacement with Custom Data Models5/30/2024 8:52:48 AM. Discover how to dynamically generate text content by replacing placeholders with actual data using a versatile TypeScript function. Enhance user engagement through personalized content delivery, appli
RESTful Day #3: Resolve Dependency of Dependencies Using Inversion of Control & Dependency Injection in ASP.Net Web APIs with Unity Container and Managed Extensibility Framework (MEF)5/24/2024 8:58:56 AM. Day 3 of RESTful learning dives into resolving dependencies of dependencies using IoC & DI in ASP.NET Web APIs. Employ Unity Container & MEF for seamless extension and management of components
Add Common Data Model(CDM) In Microsoft PowerApps5/22/2024 10:20:14 AM. The Common Data Model (CDM) in Microsoft PowerApps provides a standardized, unified data schema for integrating and managing data across various business applications. Leveraging Microsoft Dataverse,
Unique Key in SQL: Syntax, Usages, and Example5/16/2024 9:30:31 AM. Unique Key in SQL ensures each record in a database table is distinct. Syntax involves defining columns with UNIQUE constraints. It prevents duplicate values, enhancing data integrity and search effic
Entity Framework: Code First Migrations With the Existing Database5/9/2024 11:52:10 AM. Explore Entity Framework's Code First Migrations to seamlessly integrate existing databases with your application. Learn efficient techniques for data modeling, schema synchronization, and version
Simple Insert And Select (CRUD) Operation Using .NET Core MVC With ADO.NET And Entity Framework Core5/7/2024 10:33:55 AM. Learn to perform basic CRUD operations in .NET Core MVC using both ADO.NET and Entity Framework Core. Build a robust data access layer for seamless integration with your web application.
Multi-Tenant Migrations With Entity Framework 6.0 (Code First Model)5/1/2024 11:04:59 AM. Master multi-tenant migrations in Entity Framework 6.0 with ease. Learn seamless data management strategies for code-first models, ensuring robust and efficient database migrations in a multi-tenant e
Filter WebGrid With Cascading Dropdownlist Along With Paging in MVC4/30/2024 9:54:32 AM. This tutorial provides a comprehensive guide for developers new to MVC, offering step-by-step instructions for creating a basic MVC application using Visual Studio 2012 and integrating features like P
Code First Migrations With Entity Framework4/30/2024 9:39:59 AM. This article will provide answers to the following questions relevant to relationships in Entity Framework: whether or not to create a database, how to add / remove a field from an existing table, how
How To Learn Power BI And How Long It Takes To Learn Power BI4/30/2024 9:19:06 AM. Power BI, a powerful business intelligence tool by Microsoft, transforms raw data into actionable insights through reports and dashboards. Learn essential skills like data visualization, modeling, and
Data Annotations For Web Forms in .NET 4.54/29/2024 9:58:55 AM. Learn to implement data annotations for enhanced validation in ASP.NET web forms. Utilize Entity Data Model for database setup, GridView for data display, and C# for code-behind logic. Explore comple
Entity Framework - Database First Approach4/29/2024 9:54:15 AM. Learn Database First approach with Entity Framework. Utilize existing databases to create entity models. Use the ADO.Net Entity Data Model to connect. Customize model options including pluralizing, i
Data Annotations and Code First Migration in Entity Framework4/24/2024 1:18:51 PM. Explore the seamless integration of Data Annotations and Code First Migration within the Entity Framework. Learn how to leverage annotations to define data models and relationships, and master the art
Mapping TVFs Using Entity Framework Database First4/24/2024 7:43:49 AM. Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
Preview of Dynamic Data and Entity Data For EF 64/23/2024 7:23:32 AM. The preview of Dynamic Data and Entity Data for EF 6 introduces efficient database connectivity and modeling within the .NET Framework. It enables seamless integration of data with code through Entity
Select and Insert Data With Reverse Engineering Via EDM Framework4/18/2024 1:11:53 PM. Employ the Entity Data Model (EDM) framework's reverse engineering for seamless data selection and insertion. Generate code from an existing database schema, enabling efficient data access and man
Select Data Using Spatial Types Via EDF Framework 5.04/18/2024 10:28:09 AM. Explore the utilization of spatial types for data retrieval in Entity Data Model Framework 5.0. Learn how to design entities, create a web application, and implement data retrieval using Entity Frame
What is Record Keyword/Function in C#?4/3/2024 10:37:44 AM. Records introduced in C# 9.0 represent a significant enhancement to the language's capability for handling data. This article aims to explore records in-depth, covering their syntax, features, and
Database First Approach With ASP.NET MVC Step By Step Part 14/1/2024 9:47:43 AM. In this article, I will demonstrate you about Database First Approach in Entity Framework and will also show how to implement it with ASP.NET MVC.
Best Practices for Designing APIs in .NET3/26/2024 11:55:39 AM. This article provides a thorough overview of the fundamental principles, criteria, and concerns for creating APIs in.NET.
Class vs. Record vs. Struct in C#3/26/2024 4:15:44 AM. Understanding the distinctions among classes, records, and structs is vital in C# development. Classes encapsulate data and behavior, records offer immutable data modeling, while structs are lightweig
Creating Global Option Sets & Using Them Effectively in CRM3/18/2024 6:57:37 AM. To create a Global Option Set in Dynamics 365, define a set of standardized values applicable across multiple entities. Then, reference this set when creating option set fields, ensuring consistent da
Getting Started With Amazon Redshift3/15/2024 6:15:26 AM. Amazon Redshift is a powerful data warehousing service designed for analyzing large datasets. Leveraging columnar storage and parallel processing, it offers fast query performance. Redshift integrates
Create Virtual Entity in D365 CRM3/14/2024 9:55:58 AM. Creating virtual entities in D365 CRM allows the integration of external data sources seamlessly into your CRM environment. It streamlines data access, enhancing insights and decision-making without e
Implementing Common Audit Fields With EF Core’s Shadow Property3/11/2024 9:25:16 AM. Implement audit fields in EF Core using shadow properties for efficient tracking of entity modifications. Utilize Entity Framework's built-in functionality to automatically update created and modi
GraphQL In .NET Web API With Entity Framework Core - Part Two3/11/2024 9:23:26 AM. Explore advanced GraphQL integration in .NET Core Web API using Entity Framework Core. Learn efficient data modeling, schema design, and resolver implementation for seamless API development.
Practical Introduction To Entity Framework: Day 33/6/2024 10:32:09 AM. Day 3 of this practical Entity Framework introduction delves into database transactions, query optimization, and advanced EF features. Learn to manage relationships, optimize data models, and fine-tun
Building Reports With Power BI Designer Using Excel Data3/5/2024 10:30:51 AM. Transform Excel data into insightful reports with Power BI Designer. Utilize its intuitive interface and powerful features for data modeling, visualization, and dashboard creation, enabling interactiv
Build ASP.NET Core API Using Existing Database2/28/2024 10:16:53 AM. I’m sharing a short overview of Asp.NET Core. The journey of .NET Core started with the purpose of Microsoft to build a common .NET base library that provides a common foundation to all its platforms.
Quickly Provision Fabric Dataflow Gen2 Tables in Excel for Power Pivot Analysis2/26/2024 6:22:43 AM. In this video, I demo how to use popular keyboard shortcut to provision multiple tables in Dataflows Gen2 in Microsoft Fabric Data Factory to Excel for data modelling in Power Pivot
Tips to Launch Your SQL Mission2/20/2024 11:34:01 AM. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep i
What Are Relationships in Power BI2/8/2024 7:08:14 AM. This content provides an overview of the different types of relationships that can be established between tables in Power BI. It discusses four main types of relationships: many-to-one, one-to-one, on
Data Vault Design in Azure SQL - Read PII with Customer Keys2/5/2024 11:00:54 AM. Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting
Entity Framework using C#11/18/2023 11:35:55 AM. Entity framework in C# is an object relational mapping framework. In this article, we will see how to use Entity Framework in a C# application.
API Development Using Strategy Design Pattern with 3-Tier Architecture 11/13/2023 6:36:52 AM. In today's fast-paced software development landscape, creating well-structured and maintainable applications is crucial. One popular design pattern that can greatly enhance the organization and fl
What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
Using Records In C# 9.010/20/2023 7:26:18 AM. C# 9.0 introduced a significant language feature known as records, which simplifies the creation of classes for immutable data. Records provide a concise and elegant way to define classes for storing
A Guide to Avoiding Power BI Data Modeling Mistakes10/3/2023 5:55:15 AM. A Guide to Avoiding Power BI Data Modeling Mistakes.
Best Practices for Power BI Data Modeling9/24/2023 5:59:13 PM. In this article, we will learn about best practices for Power BI Data Modeling.
Task Management API with GraphQL in ASP.NET Core9/22/2023 8:16:12 AM. Creating a complete CRUD (Create, Read, Update, Delete) operation using GraphQL in an ASP.NET Core Web API can be quite extensive, so I'll provide you with a simplified example using a "Task
Advanced Sorting and Searching in ASP.NET Core Web API9/15/2023 6:48:58 AM. Sorting and searching are essential functionalities in many ASP.NET Core Web API applications. To implement advanced sorting and searching in your API, you can follow these steps:
Power BI Interview Question and Answer9/8/2023 9:02:52 AM. Power BI components, differences between Power BI Desktop and Service, query optimization techniques, DAX functions, report creation steps, data model optimization, design best practices, security mea
Exploring Statistical, Table - manipulation and Text Functions in DAX8/29/2023 4:44:35 AM. This segment goes beyond the basics and explores functions like CALCULATE, FILTER, and ALL. It covers techniques for creating dynamic measures, time intelligence functions, and handling more intricate
No Likes And Range Queries In Cassandra8/22/2023 4:44:36 AM. Cassandra's design philosophy emphasizes efficient distributed data storage and retrieval using partition keys and clustering columns. While it may not support arbitrary substring matching (No Lik
Distributed Database Management Systems1/24/2023 7:34:26 AM. I will illustrate the principles of Distributed Database Management Systems through this article.
Entity Framework Console Applications With SQL Server Compact1/16/2023 6:43:16 AM. Microsoft SQL Server Compact Edition is an embedded database system that allows us to integrate it in our Web, Desktop and Mobile applications.
Entity Framework CRUD Operations Using Stored Procedure1/11/2023 6:20:31 AM. In this post I would like to share something regarding Entity Framework, how we can implement CRUD operations using stored procedures in Entity Framework.
EF Core - Effectively Decouple The Data And Domain Model3/4/2022 7:25:36 AM. In this article. you will learn about effectively decoupling the data and domain model.
Introduction To Voice Authentication Using JavaScript12/27/2021 5:10:40 AM. Learn how to use the open-source frameworks to do the Voice recognition and validation using JavaScript and Hugging space model from Microsoft
Building ASP.NET MVC Web Applications using ADO.NET Entity Data Model11/8/2021 6:40:29 AM. This is a step by step tutorial on how to build ASP.NET MVC Web Applications using ADO.NET Entity Data Model and Visual Studio.
WCF (4), RIA Services4/28/2021 9:00:21 AM. This discuss a WCF related service, RIA service.
EntityDataSource in ASP.NET4/6/2021 10:51:50 AM. This article demonstrates an interesting and very useful concept in Entity Framework.
How to Create OData Service in ASP.NET3/26/2021 10:13:52 AM. In this article, you will learn how to create OData Service in asp.net.
Happy 155 Years Of Business Intelligence3/2/2021 3:18:15 PM. Business Intelligence is not just about turning data into information rather organizations need that to impact how their business operates and responds to the changing marketplace.
Use ADO.NET Entity Data Model in ASP.Net Scaffolding1/3/2021 9:37:47 AM. This article describes how to use the ADO.NET Entity Data Model to generate the entity and use the context in ASP.NET Scaffolding.
Creating a .edmx File using Entity Data Model11/12/2020 7:37:36 AM. This article explains how to create an edmx file, write the Lambda Expression and the last one is CRUD (Insert, Update, Delete and Select).
Entity Framework With ADO.NET Entity Data Model11/3/2020 1:41:34 AM. In this article, we will learn how to use Entity Framework with ADO.NET Data Model in Visual Studio using C#.
Dynamic Data Entities Web Application10/30/2020 4:40:21 AM. In this article I will explain how to work with a Dynamic Data Entities Web Application and show how to implement a CRUD operation without writing a single line of code.
ADO.NET : In Depth Tutorial 10/29/2020 9:02:30 AM. This tutorial describes about Building the middle tier in the Microsoft .NET Framework using ADO.NET.
Data Modeling In Power BI10/27/2020 8:45:12 AM. In this article, you will learn about Data Modeling in Power BI.
Data Model in Salesforce CRM3/23/2020 2:33:34 PM. This article will help to understand the way that Salesforce CRM platform organizes user data.
Master-Details App In Angular With Cosmos DB Using Embedded Data Modeling 5/28/2019 1:26:19 PM. In this post, we will see how to create a Master-Details application in Angular using ASP.NET Core and Cosmos DB. Instead of using multiple tables like in the traditional RDMS approach, we will use a
ComboBox Events And Dynamic Data Binding in WPF5/10/2018 7:02:30 AM. In this video we will learn to use the ComboBox events and Dynamic Data Binding. we will use the Entity Data Model to bind the ComboBox. Also we will learn the different properties of a ComboBox contr
Reuse The Model Classes Of Entity Data Model (.edmx) To Multiple Projects Using Class Library In ASP.NET Web API - Part Three4/28/2018 5:06:44 PM. A class library is useful when you want to share code between multiple programs. Class Library is a collection of reusable types including classes, interfaces and data types included in the .NET Fram
What Is Meant By Big Data9/4/2017 4:00:36 PM. Big data is a term that describes the large volume of data - both structured and unstructured - that overload a business on a day to day basis.But it's not the amount of data that's important.
Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data Model7/31/2017 11:41:47 AM. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity fram
Model First Approach in Entity Framework6/27/2017 1:32:33 AM. Read my previous two articles Code First Approach in Entity Framework & Database First Approach in Entity Framework for EF basics. In this article I'm going to directly jump into the Model Fir
MongoDB - Day 19 (MongoDB Monitoring)9/10/2015 9:20:35 AM. In this article we will learn about Monitoring in MongoDB.
MongoDB - Day 18 (Data Models)9/10/2015 2:47:18 AM. In this article you will learn about the data models in MongoDB.
Creating ASP.NET MVC APP With WCF Service4/8/2015 12:41:00 PM. In this article you will learn how to create ASP.NET MVC APP with WCF Service using ADO.NET Entity Data Model.
MongoDB With C#9/25/2014 11:31:56 PM. This article describes the basics of working with MongoDB using C#.
How to Connect ADO.NET Entity Framework With MVC in Simple Steps8/4/2014 2:36:22 PM. This article shows how to work with MVC and the ADO.NET Entity Framework together.
Using ADO .NET Entity Framework 5.011/22/2013 4:25:05 AM. This article will introduce you to the ADO.NET Entity Framework 5.0 data model, also known as the Entity Data Model (EDM).
Implement Joins in EntityFramewok Using DB Context and LINQ8/12/2013 6:47:34 PM. In this article I am sharing how to use joins in Entity Framework with a DB context and a LINQ query.
How to Use WCF RIA Service in LightSwitch 20124/4/2013 11:48:29 AM. In this article you will learn how to make a WCF RIA Service and how to consume that using Visual Studio LightSwitch 2012.
Binding Control to Data Model in Windows Store Apps10/22/2012 1:51:13 AM. In this article I will show you data binding with the data model class and how to enable reception of notifications to the user when the model is updated from the UI by the user.
Enum Support (EF Designer) in Entity Framework 59/27/2012 9:51:02 PM. Entity Framework 5 brings number of improvements and Enum Support in EF Designer or Code First is one of them. In this post you will learn it by creating a simple console application then will add EF Designer and will sketch the Model on designer surface.
Setting Null Value to an Entity Property Through Textbox Control5/15/2012 4:33:58 PM. In this article, I want to document a bug in Visual Studio. NET concerning to setting a null value to entity property’s through a Textbox control. There is a common scenario to have an entity type in your data model where some attributes are optional. When you develop a rich client application using the Windows forms, data binding techniques and a Textbox to enter the simple data, and you want to set null the optional attributes of the underlying data source by leaving in blank the Text property of the Textbox control; then there is a missing feature for the Formatting and Advanced Binding dialog box for null values. They should have a checkbox there to allow people to use blank as null. In this article, I will show one simple solution to this bug.
Generic Data Access Layer: Part 19/8/2011 9:29:47 AM. In this article we wwill be discussing how we can create a Generic Data Acess Layer which we could use in developing our Business Applications.
ADO.NET Entity Data Model in Silverlight7/26/2011 12:06:46 AM. The Entity Data Model (EDM) is an Entity-Relationship data model.
Silverlight RIA Service using ADO.NET Entity Data Model: Part II9/3/2010 12:56:06 AM. This article demonstrates how to use RIA services with ADO.NET Entity Data Model and how to use page navigation in Silverlight.
Working with Entity Data Model and Executing Stored Procedures6/21/2010 1:48:09 AM. In this article we are going to work with the following concepts that EDM support.
ADO.NET Data Model and ADO.NET Data Service in Silverlight 32/17/2010 11:21:11 PM. In this article we would see how we can use ADO.NET Entity Data Model as the ORM in Silverlight 3 Application, and ADO.NET Data Service to fetch the data.
Using ADO.NET Entity Data Model in WPF2/11/2010 11:47:06 PM. This article will show you how to fetch and show data from database using ADO.NET Entity Data Model in WPF.
Silverlight 2 use ADO.NET Data Services to access data7/22/2008 2:34:30 PM. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.

Topics