Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra security.
provide information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011 and is now supported in SQL Server 2016 Community Technology Preview 2 (CTP2).
Silverlight does not enable you to directly enumerate over a data service query. This is because enumeration automatically send a synchronous request to the data service. Because Silverlight only supports asynchronous operations, you must instead call BeginExecute and EndExecute method to obtain a query result that supports enumeration.
<tbody>
<tr *ngFor="let item of queryResult.items; let i = index">
<td class="text-center">{{ itemsPerPage * (currentPage - 1) + i + 1 }}</td>
<td class="text-center">{{ item.productId }}</td>
<td class="text-center">{{ item.productName }}</td>
<td class="text-center">{{ item.price | number:'.0' }}</td>
<td class="text-center">
<input id="item-{{ item.productId }}" type="checkbox" [checked]="item.isAvailable"
disabled="disabled" />
</td>
</tr>
</tbody>
</table> <tbody>
<tr *ngFor="let item of queryResult.items; let i = index">
<ng-container [ngTemplateOutlet]="loadTemplate(item)"
[ngOutletContext]="{ $implicit: item, idx: i }"></ng-container>
</tr>
</tbody> 
<!--The Html Template for Read-Only Rows-->
<ng-template #readOnlyTemplate let-item let-i="idx">
<td class="text-center">{{ itemsPerPage * (currentPage - 1) + i + 1 }}</td>
<td class="text-center">{{ item.productId }}</td>
<td class="text-center">{{ item.productName }}</td>
<td class="text-center">{{ item.price | number:'.0' }}</td>
<td class="text-center">
<input id="item-{{ item.productId }}" type="checkbox" [checked]="item.isAvailable"
disabled="disabled" />
</td>
<td>
<input type="button" value="Edit" class="btn btn-default btn-xs" (click)="editItem(item)"
/>
</td>
<td>
<input type="button" value="Delete" (click)="deleteItem(item)" class="btn btn-danger btn-xs"
/>
</td>
</ng-template> @ViewChild("readOnlyTemplate") readOnlyTemplate: TemplateRef<any>; 
<!--The Html Template for Editable Rows-->
<ng-template #editTemplate let-item let-i="idx">
<td class="text-center">{{ itemsPerPage * (currentPage - 1) + i + 1 }}</td>
<td class="text-center">{{ item.productId }}</td>
<td class="text-center">
<input type="text" [(ngModel)]="selectedItem.productName" class="form-control" />
</td>
<td class="text-center">
<input type="text" [(ngModel)]="selectedItem.price" class="form-control" />
</td>
<td class="text-center">
<input id="item-{{ item.productId }}" type="checkbox" [checked]="item.isAvailable"
[(ngModel)]="selectedItem.isAvailable" />
</td>
<td>
<input type="button" value="Save" (click)="saveItem()" class="btn btn-success btn-xs"
/>
</td>
<td>
<input type="button" value="Cancel" (click)="cancel()" class="btn btn-warning btn-xs"
/>
</td>
</ng-template> @ViewChild("editTemplate") editTemplate: TemplateRef<any>; @ViewChild("readOnlyTemplate") readOnlyTemplate: TemplateRef<any>;
@ViewChild("editTemplate") editTemplate: TemplateRef<any>;
selectedItem: AppProduct;
isNewRecord: boolean; editItem(item: AppProduct) {
this.selectedItem = item;
} loadTemplate(item: AppProduct) {
if (this.selectedItem && this.selectedItem.productId === item.productId) {
return this.editTemplate;
} else {
return this.readOnlyTemplate;
}
} <div class="panel"> <input type="button" value="Add new product" class="btn btn-primary" (click)="addItem()" /> </div>
addItem() {
this.selectedItem = new AppProduct(0, "", 0, false);
this.isNewRecord = true;
this.queryResult.items.push(this.selectedItem);
this.queryResult.totalItems++;
} cancel() {
this.selectedItem = null;
} deleteItem(item: AppProduct) {
this.productsService
.deleteAppProduct(item.productId)
.subscribe((resp: Response) => {
this.getPagedProductsList();
});
} saveItem() {
if (this.isNewRecord) {
this.productsService
.addAppProduct(this.selectedItem)
.subscribe((resp: AppProduct) => {
this.selectedItem.productId = resp.productId;
this.isNewRecord = false;
this.selectedItem = null;
});
} else {
this.productsService
.updateAppProduct(this.selectedItem.productId, this.selectedItem)
.subscribe((resp: AppProduct) => {
this.selectedItem = null;
});
}
} 
