<Window x:Class="WpfEventTriggerSample.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
xmlns:vm="clr-namespace:WpfEventTriggerSample.ViewModels"
Title="MainWindow" Height="350" Width="525">
<Window.Resources>
<vm:MainWindowViewModel x:Key="vmMainWindowViewModel" />
</Window.Resources>
<Grid DataContext="{Binding Source={StaticResource vmMainWindowViewModel}}">
<i:Interaction.Triggers>
<i:EventTrigger EventName="Loaded">
<i:InvokeCommandAction Command="{Binding DoLoadCommand}"
CommandParameter="I am loaded!" />
</i:EventTrigger>
</i:Interaction.Triggers>
<TextBlock Text="Testing InvokeCommandAction..."
Margin="5" VerticalAlignment="Top" />
</Grid>
</Window>
using WpfEventTriggerSample.Helper;
namespace WpfEventTriggerSample.ViewModels
{
public class MainWindowViewModel
{
public DelegateCommand<string> DoLoadCommand { set; get; }
public MainWindowViewModel()
{
DoLoadCommand = new DelegateCommand<string>(doLoadCommand, canDoLoadCommand);
}
private void doLoadCommand(string param)
{
//do something
}
private bool canDoLoadCommand(string param)
{
return true;
}
}
}
<Button>
<i:Interaction.Triggers>
<i:EventTrigger EventName="Click">
<i:InvokeCommandAction Command="{Binding DoClick}"
CommandParameter="I am loaded!" />
</i:EventTrigger>
</i:Interaction.Triggers>
</Button>
import { NgModule } from "@angular/core";
import { CommonModule } from "@angular/common";
import { BsDropdownModule } from "ngx-bootstrap/dropdown";
import { TooltipModule } from "ngx-bootstrap/tooltip";
import { ModalModule } from "ngx-bootstrap/modal";
@NgModule({
imports: [
CommonModule,
BsDropdownModule.forRoot(),
TooltipModule.forRoot(),
ModalModule.forRoot()
],
exports: [
BsDropdownModule,
TooltipModule,
ModalModule
]
})
export class SharedBootstrapModule { } import { SharedBootstrapModule } from './shared/shared.bootstrap.module';
@NgModule({
imports: [BrowserModule, SharedBootstrapModule],
// ...
})
export class AppModule {} import { SharedBootstrapModule } from "./shared.bootstrap.module";
@NgModule({
imports: [
CommonModule,
SharedBootstrapModule
],
exports: [
CommonModule,
SharedBootstrapModule
]
}) import { Component, OnInit, TemplateRef } from "@angular/core";
import { BsModalRef, BsModalService } from "ngx-bootstrap";
@Component({
selector: "app-modal-dialog-test",
templateUrl: "./modal-dialog-test.component.html",
styleUrls: ["./modal-dialog-test.component.css"]
})
export class ModalDialogTestComponent implements OnInit {
modalRef: BsModalRef;
constructor(private modalService: BsModalService) { }
openModal(template: TemplateRef<any>) {
this.modalRef = this.modalService.show(template,
{ animated: true, keyboard: true, backdrop: true, ignoreBackdropClick: false });
}
closeModal() {
this.modalRef.hide();
}
} <h1>Displaying modal bootstrap dialogs</h1>
<button type="button" class="btn btn-info" (click)="openModal(template1)">Create template modal</button>
<ng-template #template1>
<div class="modal-header">
<h4 class="modal-title pull-left">Modal</h4>
<button type="button" class="close pull-right" aria-label="Close" (click)="closeModal()">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
This is a modal.
</div>
</ng-template> 
ng g c Shared/ConfirmModal --skip-import
import { ConfirmModalComponent } from "./confirm-modal/confirm-modal.component";
@NgModule({
imports: [
],
entryComponents: [
ConfirmModalComponent
],
declarations: [
ConfirmModalComponent
]
})
export class SharedModule {} import { Component } from "@angular/core";
@Component({
selector: "app-confirm-modal",
templateUrl: "./confirm-modal.component.html",
styleUrls: ["./confirm-modal.component.css"]
})
export class ConfirmModalComponent {
args: {
title: string;
message: string;
};
close: (val?: any) => void;
} <div class="modal-header">
<h4 class="modal-title pull-left">{{ args?.title }}</h4>
<button type="button" class="close pull-right" aria-label="Close" (click)="close()">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<p>{{ args?.message }}</p>
</div>
<div class="modal-footer">
<button class="btn btn-danger" (click)="close(true)">Yes</button>
<button class="btn btn-primary" (click)="close()">Cancel</button>
</div> >ng g s Core/Modal
import { Injectable } from "@angular/core";
import { BsModalService } from "ngx-bootstrap";
@Injectable()
export class ModalService {
constructor(private bsModalService: BsModalService) { }
show(component: any, args?: any, options?: any): Promise<any> {
return new Promise(resolve => {
options = options || {};
const modal = this.bsModalService.show(component, options);
let result: any;
const sub = this.bsModalService.onHidden.subscribe(() => {
sub.unsubscribe();
resolve(result);
});
modal.content.args = args;
modal.content.close = (val?: any) => {
result = val;
modal.hide();
};
});
}
} import { ModalService } from "./modal.service";
@NgModule({
providers: [
ModalService
]
})
export class CoreModule {} <button type="button" class="btn btn-danger" (click)="deleteRecord()">Delete record</button>
<div *ngIf="confirmResult" class="alert alert-info">{{confirmResult}}</div> import { ModalService } from "./../../core/modal.service";
import { ConfirmModalComponent } from "./../../shared/confirm-modal/confirm-modal.component";
export class ModalDialogTestComponent implements OnInit {
confirmResult: string;
constructor(private modalService: ModalService) { }
deleteRecord() {
this.confirmResult = "";
this.modalService.show(
ConfirmModalComponent,
{
title: "Confirm", message: "Do you want to delete this record?"
},
{
animated: true, keyboard: true, backdrop: true, ignoreBackdropClick: false
}).then(confirmed => {
if (confirmed) {
this.confirmResult = "Deleted!";
} else {
this.confirmResult = "Canceled!";
}
});
}
} 
One or more validation errors were detected during model generation:
\tSystem.Data.Entity.Edm.EdmEntityType: : EntityType 'Blog' has no key defined.
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
namespace EF_Sample01.Models
{
public class Blog
{
[Key]
public int MyTableKey { set; get; }
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
namespace EF_Sample01.Models
{
public class Blog
{
[Key]
public int MyTableKey { set; get; }
[MaxLength(100)]
public string Title { set; get; }
[Required]
public string AuthorName { set; get; }
public IList<Post> Posts { set; get; }
}
}
CREATE TABLE [dbo].[Blogs](
[MyTableKey] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](100) NULL,
[AuthorName] [nvarchar](max) NOT NULL,
CONSTRAINT [PK_Blogs] PRIMARY KEY CLUSTERED
(
[MyTableKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
[Required(ErrorMessage = "لطفا نام نویسنده را مشخص نمائید")]
public string AuthorName { set; get; }
using System.Data.Entity;
using EF_Sample01.Models;
namespace EF_Sample01
{
public class Context : DbContext
{
public DbSet<Blog> Blogs { set; get; }
public DbSet<Post> Posts { set; get; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Blog>().HasKey(x => x.MyTableKey);
modelBuilder.Entity<Blog>().Property(x => x.Title).HasMaxLength(100);
modelBuilder.Entity<Blog>().Property(x => x.AuthorName).IsRequired();
base.OnModelCreating(modelBuilder);
}
}
}
using System.Data.Entity;
using EF_Sample01.Models;
using System.Data.Entity.ModelConfiguration;
namespace EF_Sample01
{
public class BlogConfig : EntityTypeConfiguration<Blog>
{
public BlogConfig()
{
this.Property(x => x.Id).HasColumnName("MyTableKey");
this.Property(x => x.RowVersion).HasColumnType("Timestamp");
}
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Configurations.Add(new BlogConfig());
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
namespace EF_Sample01.Models
{
[Table("tblBlogs")]
public class Blog
{
[Column("MyTableKey")]
public int Id { set; get; }
[MaxLength(100)]
public string Title { set; get; }
[Required(ErrorMessage = "لطفا نام نویسنده را مشخص نمائید")]
public string AuthorName { set; get; }
public IList<Post> Posts { set; get; }
[Timestamp]
public byte[] RowVersion { set; get; }
}
}
modelBuilder.Entity<Blog>().ToTable("tblBlogs");
modelBuilder.Entity<Blog>().Property(x => x.Id).HasColumnName("MyTableKey");
modelBuilder.Entity<Blog>().Property(x => x.RowVersion).HasColumnType("Timestamp");
System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseIfModelChanges<Context>());
// or
System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways<Context>());
public class MyInitializer : IDatabaseInitializer<Context>
{
public void InitializeDatabase(Context context)
{
if (context.Database.Exists() ||
context.Database.CompatibleWithModel(throwIfNoMetadata: false))
context.Database.Delete();
context.Database.Create();
}
}
System.Data.Entity.Database.SetInitializer(new MyInitializer());
Database.SetInitializer<Context>(null);
<appSettings>
<add key="DatabaseInitializerForType MyNamespace.MyDbContextClass, MyAssembly"
value="MyNamespace.MyInitializerClass, MyAssembly" />
</appSettings>
<appSettings>
<add key="DatabaseInitializerForType MyNamespace.MyDbContextClass, MyAssembly"
value="Disabled" />
</appSettings>
<appSettings>
<add key="DatabaseInitializerForType EF_Sample01.Context, EF_Sample01"
value="EF_Sample01.MyInitializer, EF_Sample01" />
</appSettings>
public class MyCustomInitializer : DropCreateDatabaseIfModelChanges<Context>
{
protected override void Seed(Context context)
{
context.Blogs.Add(new Blog { AuthorName = "Vahid", Title = ".NET Tips" });
context.Database.ExecuteSqlCommand("CREATE INDEX IX_title ON tblBlogs (title)");
base.Seed(context);
}
}
Server=(local);Database=yourDatabase;User ID=yourDBUser;Password=yourDBPassword;Trusted_Connection=False;Persist Security Info=True
[Table("tblBlogs", Schema="someUser")]
public class Blog
modelBuilder.Entity<Blog>().ToTable("tblBlogs", schemaName:"someUser");
PM> Install-Package RazorGenerator.Mvc
PM> Enable-RazorGenerator
Copy "$(ProjectDir)$(OutDir)$(TargetName).*" "$(SolutionDir)MvcPluginMasterApp\bin\"
using System.Web.Mvc;
namespace MvcPluginMasterApp.Plugin1.Areas.NewsArea
{
public class NewsAreaAreaRegistration : AreaRegistration
{
public override string AreaName
{
get
{
return "NewsArea";
}
}
public override void RegisterArea(AreaRegistrationContext context)
{
context.MapRoute(
"NewsArea_default",
"NewsArea/{controller}/{action}/{id}",
// تکمیل نام کنترلر پیش فرض
new { controller = "Home", action = "Index", id = UrlParameter.Optional },
// مشخص کردن فضای نام مرتبط جهت جلوگیری از تداخل با سایر قسمت‌های برنامه
namespaces: new[] { string.Format("{0}.Controllers", this.GetType().Namespace) }
);
}
}
} using System.Web.Mvc;
using System.Web.Routing;
namespace MvcPluginMasterApp
{
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional },
// مشخص کردن فضای نام مرتبط جهت جلوگیری از تداخل با سایر قسمت‌های برنامه
namespaces: new[] { string.Format("{0}.Controllers", typeof(RouteConfig).Namespace) }
);
}
}
} using System;
using System.Reflection;
using System.Web.Optimization;
using System.Web.Routing;
using StructureMap;
namespace MvcPluginMasterApp.PluginsBase
{
public interface IPlugin
{
EfBootstrapper GetEfBootstrapper();
MenuItem GetMenuItem(RequestContext requestContext);
void RegisterBundles(BundleCollection bundles);
void RegisterRoutes(RouteCollection routes);
void RegisterServices(IContainer container);
}
public class EfBootstrapper
{
/// <summary>
/// Assemblies containing EntityTypeConfiguration classes.
/// </summary>
public Assembly[] ConfigurationsAssemblies { get; set; }
/// <summary>
/// Domain classes.
/// </summary>
public Type[] DomainEntities { get; set; }
/// <summary>
/// Custom Seed method.
/// </summary>
//public Action<IUnitOfWork> DatabaseSeeder { get; set; }
}
public class MenuItem
{
public string Name { set; get; }
public string Url { set; get; }
}
} PM> install-package EntityFramework PM> install-package Microsoft.AspNet.Web.Optimization PM> install-package structuremap.web
using System.Web.Mvc;
using System.Web.Optimization;
using System.Web.Routing;
using MvcPluginMasterApp.PluginsBase;
using StructureMap;
namespace MvcPluginMasterApp.Plugin1
{
public class Plugin1 : IPlugin
{
public EfBootstrapper GetEfBootstrapper()
{
return null;
}
public MenuItem GetMenuItem(RequestContext requestContext)
{
return new MenuItem
{
Name = "Plugin 1",
Url = new UrlHelper(requestContext).Action("Index", "Home", new { area = "NewsArea" })
};
}
public void RegisterBundles(BundleCollection bundles)
{
//todo: ...
}
public void RegisterRoutes(RouteCollection routes)
{
//todo: add custom routes.
}
public void RegisterServices(IContainer container)
{
// todo: add custom services.
container.Configure(cfg =>
{
//cfg.For<INewsService>().Use<EfNewsService>();
});
}
}
} using System;
using System.IO;
using System.Threading;
using System.Web;
using MvcPluginMasterApp.PluginsBase;
using StructureMap;
using StructureMap.Graph;
namespace MvcPluginMasterApp.IoCConfig
{
public static class SmObjectFactory
{
private static readonly Lazy<Container> _containerBuilder =
new Lazy<Container>(defaultContainer, LazyThreadSafetyMode.ExecutionAndPublication);
public static IContainer Container
{
get { return _containerBuilder.Value; }
}
private static Container defaultContainer()
{
return new Container(cfg =>
{
cfg.Scan(scanner =>
{
scanner.AssembliesFromPath(
path: Path.Combine(HttpRuntime.AppDomainAppPath, "bin"),
// یک اسمبلی نباید دوبار بارگذاری شود
assemblyFilter: assembly =>
{
return !assembly.FullName.Equals(typeof(IPlugin).Assembly.FullName);
});
scanner.WithDefaultConventions(); //Connects 'IName' interface to 'Name' class automatically.
scanner.AddAllTypesOf<IPlugin>().NameBy(item => item.FullName);
});
});
}
}
} PM> install-package EntityFramework PM> install-package structuremap.web
using System.Linq;
using System.Web.Optimization;
using System.Web.Routing;
using MvcPluginMasterApp;
using MvcPluginMasterApp.IoCConfig;
using MvcPluginMasterApp.PluginsBase;
[assembly: WebActivatorEx.PostApplicationStartMethod(typeof(PluginsStart), "Start")]
namespace MvcPluginMasterApp
{
public static class PluginsStart
{
public static void Start()
{
var plugins = SmObjectFactory.Container.GetAllInstances<IPlugin>().ToList();
foreach (var plugin in plugins)
{
plugin.RegisterServices(SmObjectFactory.Container);
plugin.RegisterRoutes(RouteTable.Routes);
plugin.RegisterBundles(BundleTable.Bundles);
}
}
}
} @using MvcPluginMasterApp.IoCConfig
@using MvcPluginMasterApp.PluginsBase
@{
var plugins = SmObjectFactory.Container.GetAllInstances<IPlugin>().ToList();
}
@foreach (var plugin in plugins)
{
var menuItem = plugin.GetMenuItem(this.Request.RequestContext);
<li>
<a href="@menuItem.Url">@menuItem.Name</a>
</li>
} <div class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
@Html.ActionLink("MvcPlugin Master App", "Index", "Home", new { area = "" }, new { @class = "navbar-brand" })
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li>@Html.ActionLink("Master App/Home", "Index", "Home", new {area = ""}, null)</li>
@{ Html.RenderPartial("_PluginsMenu"); }
</ul>
</div>
</div>
</div> 
# local installation (recommended) cd <Your project root directory> dotnet new tool-manifest dotnet tool install Husky # global installation dotnet tool install --global Husky
private static void seedDb(ApplicationDbContext context)
{
if (!context.Chapters.Any())
{
var user1 = context.Users.Add(new User { Name = "Test User" });
context.Chapters.Add(new Chapter
{
Title = "Learn SQlite FTS5",
Text = "This tutorial teaches you how to perform full-text search in SQLite using FTS5",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "Advanced SQlite Full-text Search",
Text = "Show you some advanced techniques in SQLite full-text searching",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "SQLite Tutorial",
Text = "Help you learn SQLite quickly and effectively",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "Handle markup in text",
Text = "<p>Isn't this <font face=\"Comic Sans\">funny</font>?",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "آزمایش متن فارسی",
Text = "برای نمونه تهیه شده‌است",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "Exclude test 1",
Text = "in the years 2018-2019 something happened.",
User = user1.Entity
});
context.Chapters.Add(new Chapter
{
Title = "Exclude test 2",
Text = "It was 2018 and then it was 2019",
User = user1.Entity
});
context.SaveChanges();
}
} 
select * from Chapters_FTS where Chapters_FTS match "fts5"
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5"
CREATE VIRTUAL TABLE "Chapters_FTS"
USING fts5("Text", "Title", content="Chapters", content_rowid="Id") select * from Chapters_FTS where Chapters_FTS match "fts5" ORDER BY bm25(fts); select * from Chapters_FTS where Chapters_FTS match "fts5" ORDER BY rank;
namespace EFCoreSQLiteFTS.Entities
{
public class ChapterFTS
{
public int RowId { get; set; }
public decimal? Rank { get; set; }
public string Title { get; set; }
public string Text { get; set; }
}
} namespace EFCoreSQLiteFTS.DataLayer
{
public class ApplicationDbContext : DbContext
{
//...
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
builder.Entity<ChapterFTS>().HasNoKey().ToView(null);
}
//...
}
} const string ftsSql = "SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH {0}";
foreach (var chapter in context.Set<ChapterFTS>().FromSqlRaw(ftsSql, "fts5"))
{
Console.WriteLine($"Title: {chapter.Title}");
Console.WriteLine($"Text: {chapter.Text}");
} SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5"; SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS = "fts5";
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn SQLite" ORDER by rank; SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn + SQLite" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search*" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn text" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn NOT text" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search AND sqlite OR help" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search AND (sqlite OR help)" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "text:some AND title:sqlite" ORDER by rank;
"in the years 2018-2019 something happened" "It was 2018 and then it was 2019"
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "2018-2019" ORDER by rank;
Execution finished with errors. Result: no such column: 2019
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH '"2018-2019"' ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "آزمایش" ORDER by rank;
SELECT rowid, highlight(Chapters_FTS, title, '<b>', '</b>') as title, snippet(Chapters_FTS, text, '<b>', '</b>', '...', 64) as text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5" ORDER BY rank
