I was asked to show a small app that can handle an XML file and insert its content into SQL then can read the SQL data and show it. Help please…………How to insert this xml in sql server.Also i want …
Tag: sql
In this part I will show what a Business Logic Layer (BLL) should contain. We will use Repository Pattern and Unit Of Work design pattern. What are these (in few words)? Unit Of Work does 2 really important things: it …
As mentioned in the previous post, this part will show the DAL project of our Movie Inventory ASP.NET MVC web application. This small Data Access Layer class library project contains only our context declaration, the relations of the entities and …
In this tutorial I show you how easily you can create a simple ASP.NET MVC web application with Entity Framework and N-Tier architecture. The application will a simple movie inventory for home usage. You can add movies to the database …
In the following tutorial I will show you how to easily create an ASP.NET MVC Web Application with SQL usage through Entity Framework. This tutorial is mainly for newbies, beginner developers. The frontend uses HTML, CSS (and BootStrap) with Razor …
I got many questions about connecting to SQL server from C# code in the simpliest way. Now I show you some very simple static classes that you can use later in your project if you create them as a Library …
I was asked to create a simple webform that contains one DropDownList, filled up data from SQL and by selecting any of them show the associated image. First of all, I’ve created the database on the SQL server (using Windows …
There are several ways of creating connection to SQL server from your code. Some may like using the fully automatized connecting offered by Visual Studio and using that hackable app.config file. I choose this method only if I develop or …
After you finished installing SQL Server Express, you have to make some basic configurations, so you can connect easily from your Visual Studio and your application. To do this, you have to use SQL Server Manager. With Express edition of …
In this chapter I’ll show you the basic installation of SQL Server Express with screenshots. After downloading and starting the install file, choose the first option of installation: New SQL Server stand-alone installation or add features to an existing installation. …
