<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/>
<section name="syscache" type="NHibernate.Caches.SysCache.SysCacheSectionHandler, NHibernate.Caches.SysCache" requirePermission="false"/>
</configSections>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string_name">LocalSqlServer</property>
<property name="show_sql">false</property>
<property name="hbm2ddl.keywords">none</property>
<property name="cache.use_second_level_cache">true</property>
<property name="cache.use_query_cache" >true</property>
<property name="cache.provider_class">NHibernate.Caches.SysCache.SysCacheProvider, NHibernate.Caches.SysCache</property>
</session-factory>
</hibernate-configuration>
<syscache>
<cache region="LongExpire" expiration="3600" priority="5"/>
<cache region="ShortExpire" expiration="600" priority="3"/>
</syscache>
</configuration> <?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Core.Domain" namespace="Core.Domain.Model">
<class name="Organization" table="Core_Enterprise_Organization">
<cache usage="nonstrict-read-write" region="ShortExpire"/>
<id name="Id" >
<generator/>
</id>
<version name="Version"/>
<property name="Title" not-null="true" unique="true"/>
<property name="Code" not-null="true" unique="true"/>
</class>
</hibernate-mapping> <?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Core.Domain" namespace="Core.Domain.Model">
<class name="Party" table="Core_Enterprise_Party">
<id name="Id" >
<generator />
</id>
<version name="Version"/>
<property name="Username" unique="true"/>
<property name="DisplayName" not-null="true"/>
<bag name="PartyGroups" inverse="true" table="Core_Enterprise_PartyGroup" cascade="all-delete-orphan">
<cache usage="nonstrict-read-write" region="ShortExpire"/>
<key column="Party_id_fk"/>
<one-to-many/>
</bag>
</class>
</hibernate-mapping> public IList<Organization> Search(QueryOrganizationDto dto)
{
var q = SessionInstance.Query<Organization>();
if (!String.IsNullOrEmpty(dto.Title))
q = q.Where(x => x.Title.Contains(dto.Title));
if (!String.IsNullOrEmpty(dto.Code))
q = q.Where(x => x.Code.Contains(dto.Code));
q = q.OrderBy(x => x.Title);
q = q.CacheRegion("ShortExpire").Cacheable();
return q.ToList();
} [1] (object)0 == (object)0 //false [2] ((object)0).Equals((object)0) // true
git config --global core.excludesfile [path and filename]
string fileName = HttpUtility.UrlEncode(name, Encoding.UTF8);
string fileName = HttpUtility.UrlEncode(name, Encoding.UTF8);
<connectionStrings>
<clear />
<add name="DefaultConnection" connectionString="Data Source=.\sqlexpress;Initial Catalog=DecisionDb;Integrated Security = true;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
</connectionStrings> <connectionStrings>
<clear />
<add name="DefaultConnection" connectionString="Data Source=(local);Initial Catalog=DecisionDb;Integrated Security = true;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
</connectionStrings> Database.SetInitializer<ApplicationDbContext>(null);
//. . .
Sql("EXEC sp_configure filestream_access_level, 2");
Sql("RECONFIGURE", true);
Sql("alter database DecisionDb Add FileGroup FileGroupApplicant contains FileStream", true);
Sql("alter database DecisionDb add file ( name = 'ApplicantDocuements' , filename = 'C:\\FileStream\\ApplicantDocuements') to filegroup FileGroupApplicant", true);
//. . . 
PM> Update-Database -Verbose -ConnectionStringName "DefaultConnection" -StartUpProjectName "Decision.Web"
The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded.
PM> Update-Package -Reinstall "EntityFramework" -ProjectName "Decision.DataLayer"
ng new MaterialAngularClient --routing
ng g m ContactManager -m app.module --routing
import { ContactManagerModule } from "./contact-manager/contact-manager.module";
@NgModule({
imports: [
BrowserModule,
BrowserAnimationsModule,
CoreModule,
SharedModule.forRoot(),
ContactManagerModule,
AppRoutingModule
],
})
export class AppModule { } ng g c contact-manager/ContactManagerApp --no-spec
CREATE src/app/contact-manager/contact-manager-app/contact-manager-app.component.html (38 bytes) CREATE src/app/contact-manager/contact-manager-app/contact-manager-app.component.ts (319 bytes) CREATE src/app/contact-manager/contact-manager-app/contact-manager-app.component.css (0 bytes) UPDATE src/app/contact-manager/contact-manager.module.ts (436 bytes)
ng g c contact-manager/components/toolbar --no-spec ng g c contact-manager/components/main-content --no-spec ng g c contact-manager/components/sidenav --no-spec
import { NgModule } from "@angular/core";
import { RouterModule, Routes } from "@angular/router";
const routes: Routes = [
{ path: "contactmanager", loadChildren: "./contact-manager/contact-manager.module#ContactManagerModule" },
{ path: "", redirectTo: "contactmanager", pathMatch: "full" },
{ path: "**", redirectTo: "contactmanager" }
];
@NgModule({
imports: [RouterModule.forRoot(routes)],
exports: [RouterModule]
})
export class AppRoutingModule { } import { NgModule } from "@angular/core";
import { RouterModule, Routes } from "@angular/router";
import { MainContentComponent } from "./components/main-content/main-content.component";
import { ContactManagerAppComponent } from "./contact-manager-app/contact-manager-app.component";
const routes: Routes = [
{
path: "", component: ContactManagerAppComponent,
children: [
{ path: "", component: MainContentComponent }
]
},
{ path: "**", redirectTo: "" }
];
@NgModule({
imports: [RouterModule.forChild(routes)],
exports: [RouterModule]
})
export class ContactManagerRoutingModule { } <app-sidenav></app-sidenav>
<app-toolbar></app-toolbar> <router-outlet></router-outlet>
import { SharedModule } from "../shared/shared.module";
@NgModule({
imports: [
CommonModule,
SharedModule,
ContactManagerRoutingModule
]
})
export class ContactManagerModule { } 
<mat-sidenav-container *ngIf="shouldRun">
<mat-sidenav mode="side" opened>
Sidenav content
</mat-sidenav>
Primary content
</mat-sidenav-container> 
@import "~@angular/material/prebuilt-themes/indigo-pink.css";
body {
margin: 0;
} <mat-card> <h1>Main content</h1> </mat-card>
|
sidenav\sidenav.component.css | sidenav\sidenav.component.html |
.app-sidenav-container {
position: fixed;
}
.app-sidenav {
width: 240px;
}
.wrapper {
margin: 50px;
} | <mat-sidenav-container fxLayout="row"
fxFill>
<mat-sidenav #sidenav
fxFlex="1 1 100%" [opened]="!isScreenSmall"
[mode]="isScreenSmall ? 'over' : 'side'">
<mat-toolbar color="primary">
Contacts
</mat-toolbar>
<mat-list>
<mat-list-item>Item 1</mat-list-item>
<mat-list-item>Item 2</mat-list-item>
<mat-list-item>Item 3</mat-list-item>
</mat-list>
</mat-sidenav>
<mat-sidenav-content fxLayout="column" fxFlex="1 1 100%" fxFill>
<app-toolbar (toggleSidenav)="sidenav.toggle()"></app-toolbar>
<div>
<router-outlet></router-outlet>
</div>
</mat-sidenav-content>
</mat-sidenav-container> |
<app-toolbar (toggleSidenav)="sidenav.toggle()"></app-toolbar>
<mat-sidenav [opened]="!isScreenSmall" [mode]="isScreenSmall ? 'over' : 'side'">
import { Component, OnDestroy, OnInit } from "@angular/core";
import { MediaChange, ObservableMedia } from "@angular/flex-layout";
import { Subscription } from "rxjs";
@Component({
selector: "app-sidenav",
templateUrl: "./sidenav.component.html",
styleUrls: ["./sidenav.component.css"]
})
export class SidenavComponent implements OnInit, OnDestroy {
isScreenSmall = false;
watcher: Subscription;
constructor(private media: ObservableMedia) {
this.watcher = media.subscribe((change: MediaChange) => {
this.isScreenSmall = change.mqAlias === "xs";
});
}
ngOnInit() {
}
ngOnDestroy() {
this.watcher.unsubscribe();
}
} 
| toolbar\toolbar.component.css | toolbar\toolbar.component.html |
.sidenav-toggle {
padding: 0;
margin: 8px;
min-width:56px;
} | <mat-toolbar color="primary">
<button mat-button fxHide fxHide.xs="false"
class="sidenav-toggle" (click)="toggleSidenav.emit()">
<mat-icon>menu</mat-icon>
</button>
<span>Contact Manager</span>
</mat-toolbar> |
<app-toolbar (toggleSidenav)="sidenav.toggle()"></app-toolbar>
import { Component, EventEmitter, OnInit, Output } from "@angular/core";
@Component({
selector: "app-toolbar",
templateUrl: "./toolbar.component.html",
styleUrls: ["./toolbar.component.css"]
})
export class ToolbarComponent implements OnInit {
@Output() toggleSidenav = new EventEmitter<void>();
constructor() { }
ngOnInit() {
}
}