PM> Install-Package EFInteractiveViews
private static bool _isPreGeneratedViewCacheSet;
private void InitializationPreGeneratedViews()
{
if (_isPreGeneratedViewCacheSet) return;
var precompiledViewsFilePath = new FileInfo(Assembly.GetExecutingAssembly().Location).DirectoryName + @”\EF6PrecompiledViews.xml”;
InteractiveViews.SetViewCacheFactory(this, new FileViewCacheFactory(precompiledViewsFilePath));
_isPreGeneratedViewCacheSet = true;
} {
"compilerOptions": {
"strict": true,
"removeComments": false,
"sourceMap": false,
"noEmitOnError": true,
"target": "ES2020",
"module": "ES2020",
"outDir": "wwwroot/scripts"
},
"include": [
"Scripts/**/*.ts"
],
"exclude": [
"node_modules"
]
} <Project Sdk="Microsoft.NET.Sdk.Razor">
<ItemGroup>
<PackageReference Include="Microsoft.TypeScript.MSBuild" Version="4.3.5">
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
</PackageReference>
</ItemGroup>
<ItemGroup>
<Content Remove="tsconfig.json" />
</ItemGroup>
<ItemGroup>
<TypeScriptCompile Include="tsconfig.json">
<CopyToOutputDirectory>Never</CopyToOutputDirectory>
</TypeScriptCompile>
</ItemGroup>
</Project> window.exampleJsFunctions = {
showPrompt: function (message) {
return prompt(message, 'Type anything here');
}
}; namespace JSInteropWithTypeScript {
export class ExampleJsFunctions {
public showPrompt(message: string): string {
return prompt(message, 'Type anything here');
}
}
}
export function showPrompt(message: string): string {
var fns = new JSInteropWithTypeScript. ExampleJsFunctions();
return fns.showPrompt(message);
} private const string ScriptPath = "./_content/----namespace-here---/scripts/file.js"; private IJSObjectReference scriptModule;
protected override async Task OnAfterRenderAsync(bool firstRender)
{
if (scriptModule == null)
scriptModule = await JSRuntime.InvokeAsync<IJSObjectReference>("import", ScriptPath); await scriptModule.InvokeVoidAsync("exported fn name", params); public partial class MyComponent : IAsyncDisposable
public async ValueTask DisposeAsync()
{
if (scriptModule != null)
{
await scriptModule.DisposeAsync();
}
} <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>
CREATE TABLE xmlTest
(
id INT IDENTITY PRIMARY KEY,
doc XML
)
GO
INSERT xmlTest VALUES('<Person name="Vahid" />')
INSERT xmlTest VALUES('<Person name="Farid" />')
INSERT xmlTest VALUES('<Person name="Mehdi" /><Person name="Hamid" />')
GO SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')
FROM xmlTest <li>Vahid has id = 1</li>
SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')
FROM xmlTest
WHERE doc.exist('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')=1 SELECT * FROM
(
(SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
') AS col1
FROM xmlTest)
) A
WHERE CONVERT(VARCHAR(8000), col1)<>'' DECLARE @number INT = 1
SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has number = {sql:variable("@number")}</li>
')
FROM xmlTest SELECT doc.query('/Person') FROM xmlTest DECLARE @doc XML
SET @doc = (SELECT * FROM xmlTest FOR XML AUTO, ELEMENTS)
SELECT @doc.query('/xmlTest/doc/Person') DECLARE @doc XML =' <people> <person><name>Vahid</name></person> <person><name id="2">Farid</name></person> <person><name>Mehdi</name></person> <person><name>Hooshang</name><name id="1">Hooshi</name></person> <person></person> </people> '
SELECT @doc.value('/people/person/name', 'varchar(50)') SELECT @doc.value('(/people/person/name)[1]', 'varchar(50)') SELECT @doc.query('/people/person/name') <name>Vahid</name> <name id="2">Farid</name> <name>Mehdi</name> <name>Hooshang</name> <name id="1">Hooshi</name>
SELECT
tab.col.value('text()[1]', 'varchar(50)') AS name,
tab.col.query('.'),
tab.col.query('..')
from @doc.nodes('/people/person/name') AS tab(col) tab.col.query('.'), SELECT
tab.col.value('.', 'varchar(50)') AS name,
tab.col.query('data(.)'),
tab.col.query('.'),
tab.col.query('..')
from @doc.nodes('/people/person/name') AS tab(col) SELECT
tab.col.value('name[.="Farid"][1]', 'varchar(50)') AS name,
tab.col.value('name[.="Farid"][1]/@id', 'varchar(50)') AS id,
tab.col.query('.')
from @doc.nodes('/people/person[name="Farid"]') AS tab(col) DECLARE @tblXML TABLE (
id INT IDENTITY PRIMARY KEY,
doc XML
)
INSERT @tblXML VALUES('<person name="Vahid" />')
INSERT @tblXML VALUES('<person name="Farid" />')
INSERT @tblXML VALUES('<person />')
INSERT @tblXML VALUES(NULL)
SELECT
id,
doc.value('(/person/@name)[1]', 'varchar(50)') AS name
FROM @tblXML CREATE PROCEDURE LookForPhysicalOps (@op VARCHAR(30))
AS
SELECT sql.text, qs.EXECUTION_COUNT, qs.*, p.*
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(sql_handle) sql
CROSS APPLY sys.dm_exec_query_plan(plan_handle) p
WHERE query_plan.exist('
declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/showplan";
/ShowPlanXML/BatchSequence/Batch/Statements//RelOp/@PhysicalOp[. = sql:variable("@op")]
') = 1
GO
EXECUTE LookForPhysicalOps 'Table Scan'
EXECUTE LookForPhysicalOps 'Clustered Index Scan'
EXECUTE LookForPhysicalOps 'Hash Match' WITH XMLNAMESPACES(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan') SELECT RelOp.op.value(N'../../@NodeId', N'int') AS ParentOperationID, RelOp.op.value(N'@NodeId', N'int') AS OperationID, RelOp.op.value(N'@PhysicalOp', N'varchar(50)') AS PhysicalOperator, RelOp.op.value(N'@LogicalOp', N'varchar(50)') AS LogicalOperator, RelOp.op.value(N'@EstimatedTotalSubtreeCost ', N'float') AS EstimatedCost, RelOp.op.value(N'@EstimateIO', N'float') AS EstimatedIO, RelOp.op.value(N'@EstimateCPU', N'float') AS EstimatedCPU, RelOp.op.value(N'@EstimateRows', N'float') AS EstimatedRows, cp.plan_handle AS PlanHandle, st.TEXT AS QueryText, qp.query_plan AS QueryPlan, cp.cacheobjtype AS CacheObjectType, cp.objtype AS ObjectType FROM sys.dm_exec_cached_plans cp CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp CROSS APPLY qp.query_plan.nodes(N'//RelOp') RelOp(op)
DECLARE @doc XML = ' <Invoice> <InvoiceId>100</InvoiceId> <CustomerName>Vahid</CustomerName> <LineItems> <LineItem> <Sku>134</Sku> <Quantity>10</Quantity> <Description>Item 1</Description> <UnitPrice>9.5</UnitPrice> </LineItem> <LineItem> <Sku>150</Sku> <Quantity>5</Quantity> <Description>Item 2</Description> <UnitPrice>1.5</UnitPrice> </LineItem> </LineItems> </Invoice> '
SET @doc.modify('
insert <InvoiceInfo><InvoiceDate>2014-02-10</InvoiceDate></InvoiceInfo>
after /Invoice[1]/CustomerName[1]
')
SELECT @doc <Invoice>
<InvoiceId>100</InvoiceId>
<CustomerName>Vahid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems>
... SET @x.modify('insert sql:variable("@x") into /doc[1]') The argument 1 of the XML data type method "modify" must be a string literal.
SET @doc.modify('
insert attribute status{"backorder"}
into /Invoice[1]
')
SELECT @doc <Invoice status="backorder"> <InvoiceId>100</InvoiceId> ....
SET @doc.modify('delete /Invoice/LineItems/LineItem')
SELECT @doc <Invoice status="backorder">
<InvoiceId>100</InvoiceId>
<CustomerName>Vahid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems />
</Invoice> SET @doc.modify('replace value of
/Invoice[1]/CustomerName[1]/text()[1]
with "Farid"
')
SELECT @doc <Invoice status="backorder">
<InvoiceId>100</InvoiceId>
<CustomerName>Farid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems />
</Invoice> The target of 'replace value of' must be a non-metadata attribute or an element with simple typed content.
DECLARE @tblTest AS TABLE (xmlField XML)
INSERT INTO @tblTest(xmlField)
VALUES
(
'<Sample>
<Node1>Value1</Node1>
<Node2>Value2</Node2>
<Node3/>
</Sample>'
)
DECLARE @newValue VARCHAR(50) = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'insert text{sql:variable("@newValue")} into
(/Sample/Node3)[1] [not(text())]'
)
SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3/text())[1]
with sql:variable("@newValue")'
) using System.IO;
using WkHtmlToXSharp;
using System;
namespace Test2
{
public class WkHtmlToXSharpTest
{
public static void ConvertHtmlStringToPdfTest()
{
using (var wk = new MultiplexingConverter())
{
wk.Begin += (s, e) => Console.WriteLine("Conversion begin, phase count: {0}", e.Value);
wk.Error += (s, e) => Console.WriteLine(e.Value);
wk.Warning += (s, e) => Console.WriteLine(e.Value);
wk.PhaseChanged += (s, e) => Console.WriteLine("PhaseChanged: {0} - {1}", e.Value, e.Value2);
wk.ProgressChanged += (s, e) => Console.WriteLine("ProgressChanged: {0} - {1}", e.Value, e.Value2);
wk.Finished += (s, e) => Console.WriteLine("Finished: {0}", e.Value ? "success" : "failed!");
wk.GlobalSettings.Margin.Top = "0cm";
wk.GlobalSettings.Margin.Bottom = "0cm";
wk.GlobalSettings.Margin.Left = "0cm";
wk.GlobalSettings.Margin.Right = "0cm";
wk.ObjectSettings.Web.EnablePlugins = false;
wk.ObjectSettings.Web.EnableJavascript = false;
wk.ObjectSettings.Load.Proxy = "none";
var htmlString = File.ReadAllText(@"c:\page.xhtml");
var tmp = wk.Convert(htmlString);
File.WriteAllBytes(@"tst.pdf", tmp);
}
}
}
}
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
سال‌ها است که IDEهای Jetbrains برای اینکه در سکوهای کاری متفاوت قابل اجرا باشند، با جاوا نوشته میشوند. برای مثال Rider که یک IDE مخصوص دات نت است نیز با جاوا نوشته شده‌است و مابقی آن‌ها نیز به همین صورت. اگر به مسیر C:\Program Files\JetBrains\JetBrains Rider 2018.3.4\bin\rider64.exe.vmoptions مراجعه کنید، فایل با پسوند vmoptions در حقیقت تنظیمات Java Virtual Machine یا JVM را به همراه دارد. این فایل طوری تنظیم شده‌است که کمترین منابع را مصرف کند؛ به همین جهت شاید در حین کار کردن با این IDEها احساس کنید که کند هستند. تنظیمات JVM مخصوص جاوای ویندوز و جاوای مک و لینوکس را در اینجا و اینجا میتوانید مطالعه کنید.
اگر بر این اساس فایل rider64.exe.vmoptions را بخواهیم تکمیل کنیم، می‌توان به تنظیمات زیر رسید:
-Xms1024m -Xmx3072m -Xss64m -XX:ReservedCodeCacheSize=512m -XX:+UseCompressedOops -XX:NewRatio=2 -Dfile.encoding=UTF-8 -XX:+UseConcMarkSweepGC -XX:SoftRefLRUPolicyMSPerMB=250 -XX:NewSize=512m -XX:MaxNewSize=512m -XX:PermSize=512m -XX:MaxPermSize=1024m -XX:+UseParNewGC -XX:ParallelGCThreads=4 -XX:MaxTenuringThreshold=1 -XX:SurvivorRatio=8 -XX:+UseCodeCacheFlushing -XX:+AggressiveOpts -XX:+CMSClassUnloadingEnabled -XX:+CMSIncrementalMode -XX:+CMSIncrementalPacing -XX:+CMSParallelRemarkEnabled -XX:CMSInitiatingOccupancyFraction=65 -XX:+CMSScavengeBeforeRemark -XX:+UseCMSInitiatingOccupancyOnly -XX:-TraceClassUnloading -XX:+AlwaysPreTouch -XX:+TieredCompilation -XX:+DoEscapeAnalysis -XX:+UnlockExperimentalVMOptions -XX:LargePageSizeInBytes=256m -XX:+DisableExplicitGC -XX:+ExplicitGCInvokesConcurrent -XX:+PrintGCDetails -XX:+PrintFlagsFinal -XX:+CMSPermGenSweepingEnabled -XX:+UseAdaptiveGCBoundary -XX:+UseSplitVerifier -XX:CompileThreshold=10000 -XX:+OptimizeStringConcat -XX:+UseStringCache -XX:+UseFastAccessorMethods -XX:+UnlockDiagnosticVMOptions -ea -Dsun.io.useCanonCaches=false -Djava.net.preferIPv4Stack=true -Djdk.http.auth.tunneling.disabledSchemes="" -XX:+HeapDumpOnOutOfMemoryError -XX:-OmitStackTraceInFastThrow -Xverify:none
پس از این تغییرات اگر Rider را اجرا کنید، حداقل نسبت به قبل دو برابر RAM مصرف خواهد کرد. همچنین بار اولی که برنامه را اجرا میکنید، چون تعدادی از این تنظیمات بر روی نحوه‌ی JIT تاثیرگذار هستند، کمی طول می‌کشد تا کار کامپایل جدید آن صورت گیرد و از دفعات آتی اجرای آن، بهبود کارآیی را احساس خواهید کرد.
علاوه بر موارد فوق، فایل C:\Program Files\JetBrains\JetBrains Rider 2018.3.4\bin\idea.properties را نیز میتوانید جهت اعمال تغییرات زیر ویرایش کنید:
idea.max.intellisense.filesize=3500 idea.cycle.buffer.size=2048
<?xml version="1.0" encoding="utf-8"?> <packages> <package id="Microsoft.AspNet.OData" version="6.0.0" targetFramework="net462" /> <package id="Microsoft.AspNet.SignalR.Core" version="2.2.1" targetFramework="net462" /> <package id="Microsoft.AspNet.SignalR.Owin" version="1.2.2" targetFramework="net462" /> <package id="Microsoft.AspNet.WebApi.Client" version="5.2.3" targetFramework="net462" /> <package id="Microsoft.AspNet.WebApi.Core" version="5.2.3" targetFramework="net462" /> <package id="Microsoft.AspNet.WebApi.Owin" version="5.2.3" targetFramework="net462" /> <package id="Microsoft.CodeDom.Providers.DotNetCompilerPlatform" version="1.0.2" targetFramework="net462" /> <package id="Microsoft.Extensions.DependencyInjection" version="1.0.0" targetFramework="net462" /> <package id="Microsoft.Extensions.DependencyInjection.Abstractions" version="1.0.0" targetFramework="net462" /> <package id="Microsoft.Net.Compilers" version="1.3.2" targetFramework="net462" developmentDependency="true" /> <package id="Microsoft.OData.Core" version="7.0.0" targetFramework="net462" /> <package id="Microsoft.OData.Edm" version="7.0.0" targetFramework="net462" /> <package id="Microsoft.Owin" version="3.0.1" targetFramework="net462" /> <package id="Microsoft.Owin.FileSystems" version="3.0.1" targetFramework="net462" /> <package id="Microsoft.Owin.Host.SystemWeb" version="3.0.1" targetFramework="net462" /> <package id="Microsoft.Owin.Security" version="3.0.1" targetFramework="net462" /> <package id="Microsoft.Owin.StaticFiles" version="3.0.1" targetFramework="net462" /> <package id="Microsoft.Spatial" version="7.0.0" targetFramework="net462" /> <package id="Newtonsoft.Json" version="9.0.1" targetFramework="net462" /> <package id="Owin" version="1.0" targetFramework="net462" /> <package id="System.Collections" version="4.0.11" targetFramework="net462" /> <package id="System.Collections.Concurrent" version="4.0.12" targetFramework="net462" /> <package id="System.ComponentModel" version="4.0.1" targetFramework="net462" /> <package id="System.Diagnostics.Debug" version="4.0.11" targetFramework="net462" /> <package id="System.Globalization" version="4.0.11" targetFramework="net462" /> <package id="System.Linq" version="4.1.0" targetFramework="net462" /> <package id="System.Linq.Expressions" version="4.1.0" targetFramework="net462" /> <package id="System.Reflection" version="4.1.0" targetFramework="net462" /> <package id="System.Resources.ResourceManager" version="4.0.1" targetFramework="net462" /> <package id="System.Runtime.Extensions" version="4.1.0" targetFramework="net462" /> <package id="System.Threading" version="4.0.11" targetFramework="net462" /> <package id="System.Threading.Tasks" version="4.0.11" targetFramework="net462" /> </packages>
PM>Update-Package -reinstall -Project YourProjectName
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="owin:AppStartup" value="OwinKatanaTest.OwinAppStartup, OwinKatanaTest" />
<!-- Owin App Startup Class -->
<add key="webpages:Enabled" value="false" />
<!-- Disable asp.net web pages. Note that based on our current configuration, asp.net web forms, mvc and web pages won't work. This configuration is for owin stuffs only, for example asp.net web api & odata, signalr, etc. -->
</appSettings>
<system.web>
<compilation debug="true" defaultLanguage="c#" enablePrefetchOptimization="true" optimizeCompilations="true" targetFramework="4.6.2">
<assemblies>
<remove assembly="*" />
<!-- To improve app startup performance, our app will continue its work without this compilations, these are required for asp.net web forms, mvc and web pages. -->
<add assembly="OwinKatanaTest" />
</assemblies>
</compilation>
<httpRuntime targetFramework="4.6.2" />
<httpModules>
<!-- No need to these modules and handlers, owin handler itself will do everything for us -->
<clear />
</httpModules>
<httpHandlers>
<clear />
</httpHandlers>
<sessionState mode="Off" />
</system.web>
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:6 /nowarn:1659;1699;1701" />
</compilers>
</system.codedom>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin.Security" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.AspNet.SignalR.Core" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-2.2.1.0" newVersion="2.2.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Reflection" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-4.1.0.0" newVersion="4.1.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Runtime.Extensions" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-4.1.0.0" newVersion="4.1.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Http" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
<modules runAllManagedModulesForAllRequests="false">
<!-- We're not going to remove all modules, some modules such as static & dynamic compression modules are really cool (-: -->
<remove name="RewriteModule" />
<remove name="OutputCache" />
<remove name="Session" />
<remove name="WindowsAuthentication" />
<remove name="FormsAuthentication" />
<remove name="DefaultAuthentication" />
<remove name="RoleManager" />
<remove name="FileAuthorization" />
<remove name="UrlAuthorization" />
<remove name="AnonymousIdentification" />
<remove name="Profile" />
<remove name="UrlMappingsModule" />
<remove name="ServiceModel-4.0" />
<remove name="UrlRoutingModule-4.0" />
<remove name="ScriptModule-4.0" />
<remove name="Isapi" />
<remove name="IsapiFilter" />
<remove name="DigestAuthentication" />
<remove name="WindowsAuthentication" />
<remove name="ServerSideInclude" />
<remove name="DirectoryListing" />
<remove name="DefaultDocument" />
<remove name="CustomError" />
<remove name="Cgi" />
</modules>
<defaultDocument>
<!-- Default docs will be configured using owin static files middleware -->
<files>
<clear />
</files>
</defaultDocument>
<handlers>
<!-- Only use this handler for all requests -->
<clear />
<add name="Owin" verb="*" path="*" type="Microsoft.Owin.Host.SystemWeb.OwinHttpHandler, Microsoft.Owin.Host.SystemWeb" />
</handlers>
<httpProtocol>
<customHeaders>
<clear />
</customHeaders>
</httpProtocol>
</system.webServer>
</configuration> using Microsoft.AspNet.SignalR;
using Microsoft.OData;
using Microsoft.OData.Edm;
using Owin;
using OwinKatanaTest.Model;
using OwinKatanaTest.ODataControllers;
using System.Collections.Generic;
using System.Web.Http;
using System.Web.OData.Builder;
using System.Web.OData.Extensions;
using System.Web.OData.Routing.Conventions;
namespace OwinKatanaTest
{
public class OwinAppStartup
{
public void Configuration(IAppBuilder owinApp)
{
owinApp.Map("/odata", innerOwinAppForOData =>
{
HttpConfiguration webApiODataConfig = new HttpConfiguration();
webApiODataConfig.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;
webApiODataConfig.Formatters.Clear();
IEnumerable<IODataRoutingConvention> conventions = ODataRoutingConventions.CreateDefault();
ODataModelBuilder modelBuilder = new ODataConventionModelBuilder(webApiODataConfig);
modelBuilder.Namespace = modelBuilder.ContainerName = "Test";
var categoriesSetConfig = modelBuilder.EntitySet<Category>("Categories");
var getBestCategoryFunctionConfig = categoriesSetConfig.EntityType.Collection.Function(nameof(CategoriesController.GetBestCategory));
getBestCategoryFunctionConfig.ReturnsFromEntitySet<Category>("Categories");
IEdmModel edmModel = modelBuilder.GetEdmModel();
webApiODataConfig.MapODataServiceRoute("default", "", builder =>
{
builder.AddService(ServiceLifetime.Singleton, sp => conventions);
builder.AddService(ServiceLifetime.Singleton, sp => edmModel);
});
innerOwinAppForOData.UseWebApi(webApiODataConfig);
});
owinApp.Map("/api", innerOwinAppForWebApi =>
{
HttpConfiguration webApiConfig = new HttpConfiguration();
webApiConfig.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;
webApiConfig.MapHttpAttributeRoutes();
webApiConfig.Routes.MapHttpRoute(name: "default", routeTemplate: "{controller}/{action}", defaults: new { action = RouteParameter.Optional });
innerOwinAppForWebApi.UseWebApi(webApiConfig);
});
owinApp.Map("/signalr", innerOwinAppForSignalR =>
{
innerOwinAppForSignalR.RunSignalR(new HubConfiguration
{
EnableDetailedErrors = true
});
});
owinApp.UseStaticFiles();
owinApp.Run(async context =>
{
await context.Response.WriteAsync("owin katana");
});
}
}
} using OwinKatanaTest.Model;
using System.Web.Http;
using System.Web.OData;
namespace OwinKatanaTest.ODataControllers
{
public class CategoriesController : ODataController
{
[HttpGet]
public Category GetBestCategory()
{
return new Category { Id = 1, Name = "Test" };
}
}
} using OwinKatanaTest.Model;
using System.Collections.Generic;
using System.Web.Http;
namespace OwinKatanaTest.ApiControllers
{
public class ProductsController : ApiController
{
[HttpGet]
[Route("products/{categoryId}")]
public List<Product> GetProductsByCategoryId(int categoryId)
{
return new List<Product>
{
new Product { Id = 1 , Name = "Test" }
};
}
}
} <package id="Microsoft.Owin.Testing" version="3.0.1" targetFramework="net462" />
using Microsoft.Owin.Testing;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using OwinKatanaTest;
using System.Net;
using System.Net.Http;
using System.Threading.Tasks;
namespace Test
{
[TestClass]
public class Test
{
[TestMethod]
public async Task TestWebApi()
{
using (TestServer server = TestServer.Create<OwinAppStartup>())
{
HttpResponseMessage apiResponse = await server.HttpClient.GetAsync("/api/products/1");
apiResponse.EnsureSuccessStatusCode();
Assert.AreEqual(HttpStatusCode.OK, apiResponse.StatusCode);
}
}
[TestMethod]
public async Task TestOData()
{
using (TestServer server = TestServer.Create<OwinAppStartup>())
{
HttpResponseMessage odataResponse = await server.HttpClient.GetAsync("odata/Categories/Test.GetBestCategory");
odataResponse.EnsureSuccessStatusCode();
Assert.AreEqual(HttpStatusCode.OK, odataResponse.StatusCode);
}
}
}
} 