namespace EnablingMARS.Models
{
public class Product
{
public int Id { get; set; }
public string Title { get; set; }
public string Desc { get; set; }
public float Price { get; set; }
public Category Category { get; set; }
}
public enum Category
{
Cate1,
Cate2,
Cate3
}
} namespace EnablingMARS.Models
{
public class ProductDbContext : DbContext
{
public ProductDbContext() : base("EnablingMARS") {}
public DbSet<Product> Products { get; set; }
}
} MyContext.Products.Add(new Product()
{
Title = "title1",
Desc = "desc",
Price = 4500f,
Category = Category.Cate1
});
MyContext.SaveChanges(); foreach (var product in _dvContext.Products.Where(category => category.Category == Category.Cate1))
{
product.Price = 50000;
MyContext.SaveChanges();
} There is already an open DataReader associated with this Command which must be closed first.
"Data Source=(LocalDB)\v11.0;Initial Catalog=EnablingMARS; MultipleActiveResultSets=true"
// cardCatalog.d.ts
declare module "CardCatalog"{
export function printCard(callNumber: string): void;
} // app.ts /// <reference path="cardCatalog.d.ts" /> import * as catalog from "CardCatalog";
npm init -f npm install lodash --save
declare module "lodash" {
export = _;
} /// <reference path="lodash.d.ts" />
import * as _ from "lodash";
let snakeCaseTitle = _.snakeCase("test this");
console.log(snakeCaseTitle); 
npm install tsd -g
D:\Prog\1395\VSCodeTypeScript>tsd install lodash --save
[ERR!] Error: connect ECONNREFUSED 10.10.34.36:443
/// <reference path="./typings/tsd.d.ts" />
npm install typings --global
typings install lodash --ambient --save
typings ERR! caused by Unable to connect to "https://raw.githubusercontent.com/DefinitelyTyped/DefinitelyTyped/299b5caa22876ef27dc8e9a5b7fd7bf93457b6f4/lodash/lodash-3.10.d.ts" typings ERR! caused by connect ECONNREFUSED 10.10.34.36:443
/// <reference path="./typings/main.d.ts" />
Select * into DestinationDB.dbo.tableName from SourceDB.dbo.SourceTable
select * into databaseto.dbo.emp from databasefrm.dbo.Emp
select * into newtable from SourceTable
select * into emp1 from emp
select col1, col2 into <destination_table> from <source_table>
select Id,Name into databaseto.dbo.emp1 from databasefrm.dbo.Emp
کد فوق باعث کپی کردن فیلد‌های Id,Name شده است.
اگر بخواهیم فقط ساختار جدول را کپی کنیم روند کار به صورت زیر خواهد بود :
select *into <destination_database.dbo.destination table> from _ <source_database.dbo.source table> where 1 = 2
select * into databaseto.dbo.emp from databasefrm.dbo.emp where 1 = 2
select top(0) * into databaseto.dbo.emp from databasefrm.dbo.emp
و میخواهید توسط outer join لیست تمامی پرسنل و محل تولد و محل صدور را (در صورت وجود) داشته باشید.
در sql گرفتن نتیجه ذکر شده بصورت زیر به راحتی قابل انجام است
SELECT
dbo.tbl_Personnel.ID,
dbo.tbl_Personnel.FirstName,
dbo.tbl_Personnel.LastName,
dbo.tbl_GeographyPosition.Title AS IssuanceLocation,
tbl_GeographyPosition_1.Title AS BirthLocation
FROM dbo.tbl_Personnel LEFT OUTER JOIN
dbo.tbl_GeographyPosition AS tbl_GeographyPosition_1 ON
dbo.tbl_Personnel.BirthLocationGeographyPositionID = tbl_GeographyPosition_1.ID LEFT OUTER JOIN
dbo.tbl_GeographyPosition ON dbo.tbl_Personnel.IssuanceLocationGeographyPositionID = dbo.tbl_GeographyPosition.ID اما در ef با توجه به خواص راهبری کمتر از join استفاده میکنیم در ضمن به هیچ وجه از Left Outer Join و Right Outer Join استفاده نمی‌شود و باید کوئری فوق را با کد زیر شبیه سازی کرد
var contex = new PersonnelEntities();
var Query = from Personnel in contex.tbl_Personnel
join IssuanceLocation in contex.tbl_GeographyPosition on
Personnel.IssuanceLocationGeographyPositionID equals IssuanceLocation.ID into AIssuanceLocation
from IL in AIssuanceLocation.DefaultIfEmpty()
join BirthLocation in contex.tbl_GeographyPosition on
Personnel.BirthLocationGeographyPositionID equals BirthLocation.ID into ABirthLocation
from BL in ABirthLocation.DefaultIfEmpty()
//where
select new
{
Personnel.ID,
Personnel.FirstName,
Personnel.LastName,
IssuanceLocation = IL.Title,
BirthLocation = BL.Title
}; SELECT sum([Rating_TotalRating]), sum([Rating_TotalRaters]), sum([Rating_AverageRating]) FROM [BlogPosts]
context.BlogPost.Select(r =>
new
{
Sum1 = r.Sum(x => x.RatingTotalRating),
Sum2 = r.Sum(x => x.RatingTotalRaters),
Sum3 = r.Sum(x => x.RatingAverageRating)
}).FirstOrDefault(); var sum1 = context.BlogPost.Sum(x => x.RatingTotalRating); var sum2 = context.BlogPost.Sum(x => x.RatingTotalRaters); var sum2 = context.BlogPost.Sum(x => x.RatingAverageRating);
context.BlogPost
.GroupBy(dummyNumber => 0)
.Select(r =>
new
{
Sum1 = r.Sum(x => x.RatingTotalRating),
Sum2 = r.Sum(x => x.RatingTotalRaters),
Sum3 = r.Sum(x => x.RatingAverageRating)
}).FirstOrDefault(); SELECT TOP (1)
[Extent1].[K1] AS [K1],
Sum([Extent1].[A1]) AS [A1],
Sum([Extent1].[A2]) AS [A2],
Sum([Extent1].[A3]) AS [A3]
FROM ( SELECT
0 AS [K1],
[Extent1].[RatingTotalRating] AS [A1],
[Extent1].[RatingTotalRaters] AS [A2],
[Extent1].[RatingAverageRating] AS [A3]
FROM [dbo].[BlogPosts] AS [Extent1]
) AS [Extent1]
GROUP BY [K1]
USE dbName;
SELECT OBJECT_NAME(DMV.object_id) AS TABLE_NAME,
SI.NAME AS INDEX_NAME,
avg_fragmentation_in_percent AS FRAGMENT_PERCENT,
DMV.record_count
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'SAMPLED') AS
DMV
LEFT OUTER JOIN SYS.INDEXES AS SI
ON DMV.OBJECT_ID = SI.OBJECT_ID
AND DMV.INDEX_ID = SI.INDEX_ID
WHERE avg_fragmentation_in_percent > 10
AND index_type_desc IN ('CLUSTERED INDEX', 'NONCLUSTERED INDEX')
AND DMV.record_count >= 2000
ORDER BY
TABLE_NAME DESC
DECLARE @TableName VARCHAR(255)
DECLARE @sql NVARCHAR(500)
DECLARE @fillfactor INT
SET @fillfactor = 80
DECLARE TableCursor CURSOR
FOR
SELECT OBJECT_SCHEMA_NAME([object_id]) + '.' + NAME AS TableName
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = 'ALTER INDEX ALL ON ' + @TableName +
' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3), @fillfactor) + ')'
EXEC (@sql)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor