Data Haunting

Easy Solutions Destination

Pages

By

Difference between code first and database first and model first approach in entity framework

Entity Framework has mainly three different types of design approaches like Code First Approach, Database First Approach and Model First Approach. In this article we will compare all these approaches with advantages and disadvantages and will try to understand the basic difference of Code First Approach vs Database First Approach vs Model First Approach in Entity Framework.

By

Understand Sql Server Cursor with Example

Operations in a relational database act on a complete set of rows. This complete set of rows returned by the statement is known as the result set. Sql server Cursor is a database objects to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time. We can use cursor when we need to update records in a database table row by row. In this article we will see how to use Sql Server Cusror with Example.

By

Entity framework delete object without retrieving it

In Entity Framework to delete an Object, we first fetched the object and than delete that particular object or record. This one result in to performance penalty as there are two SQL query executed first one for “Select” query and second one for “Delete” query. In Entity Framework 6.0 or above Microsoft provide solution to delete an object(record) with out retrieving or fetching it.

By

How AngulaJs is better than Jquery ?

AngularJs is open source Javascript framework developed by Google which is the most popular and dominant JavaScript framework suits for any sized web app and web application while Jquery is write less, do more Javascript Libraby which is very popular for last many years. So now the question is that How AngualrJs is better than classic Jquery Library ? In this article we will see that What are the core differentiation which makes AngularJs better than Jquery.

By

Sql server check if column exists in table

In Sql server if we want to be sure that specific column exists in given database table or not than you can check either manually or using query for large number of columns of table. In this tutorial we will see how to check if column exist in database table.

By

File Uploading in Asp.net MVC

In this article we will see that how to upload a file in Asp.net MVC as well we go through different different criteria like single file upload, multiple files upload and strongly type viewmodel file upload in MVC.

By

Insert Multiple Rows in a single query in Sql Server

Recently I have faced this question in interview that how to add or insert multiple rows in a single query at once. So I have find out two different solutions for this query. Let’s see the solutions.

By

How to find Host name, Server name, User name and DataBase name in Sql server

Frequently in interview we face the question that how to get Host name(machine name), Server name, User name and DataBase name of Sql Server which are connected in Networks. In this article we will see that how to find Host name(machine name), Server name, User name and DataBase name using Sql select query in Sql Server management studio which is quite easy.

By

Render a Razor view to string in Asp.net MVC

Today in this article we will see how to render razor view or partial view to string in Asp.net MVC. View or partial view contains generally html tags and razor syntax, if we can convert view into string using C# than we can pass string as a Json Result from controller to view(for Ajax call). Let’s see sample code.

By

Jquery Ui Uncaught TypeError : Undefined is not a function

While working with Jquery Ui we have many times face this Jquery or Javascript error that uncaught typerror undefined is not a function. Many times I have also face this Jquery Ui error and so I find all reasons and solutions for this Jquery Ui Uncaught TypeError : Undefined is not a function error.