DbContext class is the one among others that the Entity Framework team has created, in order to facilitate developers when accessing and manipulating database data. In a nutshell, DbContext, DbSet, and DbQuery are the classes that have encapsulated the most… Read More ›
Code First doesn’t support Stored Procedure mapping by default, at least in the way Database First does (from the designer window). More over, it has an unusuall way to map a Domain Model class to a database view. This post… Read More ›
Code First approach allows you to create the Domain Model classes on your own and let Entity Framework do the hard work creating the actual database for you. We have seen in previous post an introduction in Code First development… Read More ›
Code First is probably the most preferred way to build an Entity Data Model that can be used with Entity Framework to perform data access. Database First and Model First are the also quite important but less used. In Code… Read More ›
In ADO.NET you can compute Child or Parent column values, coming from DataTable objects that are related using a DataRelation between them. If you don’t know how DataRelation is used in ADO.NET read a previous post of these ADO.NET series…. Read More ›
Knowing to work with the offline ADO.NET classes such as DataSet and DataTable, is the Alpha and the Omega in ADO.NET before actually start queering real database data. You need to understand that ADO.NET divides it’s classes in two major… Read More ›
If you aren’t new to .NET development you will be aware that there are several different ways to access and manipulate database data. New developers always use the build in Visual Studio features such as SqlDataSource or EntityDataSource. These are… Read More ›
The fundamentals operations that a storage system provides are the CRUD ones. CRUD stands for CREATE, READ, UPDATE, DELETE and corresponds to the SQL statements INSERT, SELECT, UPDATE and DELETE respectively. This post will show you how to query CRUD… Read More ›
LINQ to SQL is a LINQ implementation which can be used to query relational Microsoft SQL Server database, in an object oriented way. You can create an object model (classes) that maps your relational database tables, then query against this… Read More ›
In previous post we saw the fundamentals around querying data using LINQ . There are three basic LINQ implementations and this post will give you code examples for the main implementation of the Microsoft Language Integrated Query, LINQ to Objects. In… Read More ›
chsakell's Blog 