Search In
Entity Framework (EF) is an ORM framework. ORM stands for object-relational Mapping.
Now what is object-relational Mapping..
Object-Relational Mapping framework it self creates model classes depending on tables of database, and vise versa. It can
Databases whose data is not required to be changed should be considered to be set as READ ONLY.Databases can be set to READ ONLY mode and back using T-SQL and SSMS.
Following are the scripts that can be used to set database read only and back:
--
SQL follow the unique set of rules that is called syntax ,follow the rules given below
SQL database is not a case sensitive . Generally in SQL database keywords are written in uppercase
SQL statements are dependent on text lines .
You can do task
Suppose we have a string with full path with filename and we want to extract only the filename from the given path, then we can use Path.GetFileName method to extract only the file name.
Syntax: filename= Path.GetFileName(path);
Where path is par
We can find the hours between two dates by using NSDateFormatter. NSDateFormatter provides formatting and conversion methods for NSDate objects. In below code, I have used formatter to convert the start date and end date into hours and minutes where
Sometimes we get this error on creating table in MySQL.This error will come when we use the constraint with the same name that is already used somewhere else.
If the table you're trying to create includes a foreign key constraint, and you've provide
Hello Readers.
Node.js is very popular in market in creating of real time applications.Here's the example of how we can create the server in our local system to run the Node.js applications.
var http = require('http')
, static = require('no
Hello All,
Many time, We want to know that, What are all the tables who have referenced a column as a "foreign key" which is a "Primary Key" of other table.
Example:-- In a database I have one Company table which stores company information with Co
Hello guys,
Most of time we face the problem order by within IN() values . Mysql provides the function FIELD(), It will sort fetched IN() data according to requirment . The FIELD function returns the position of the first string in the remaining list
Many times we need to truncate a table which has an FK constraint on it. Typically we get the following error:
Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.
The solution to the above problem is to fol
