Kontext Project

Kontext is multi-user cross-platform blog web application created by Raymond Tang using the latest technologies, including .NET Standard 2.0, ASP.NET Core 2.0 MVC, Entity Framework Core 2.0, Xml-RPC, SQL Server, Azure, VSTS, Bootstrap 4.0, Font Awesome and etc.

Learn more

New domain kontext.tech is now in use

55 views 0 comments posted at about 2 months ago

kosmisch.net is recently upgraded to Azure and a new domain kontext.tech is in use.

View detail

Teradata Tutorials Summary - October 2017

56 views 0 comments posted at about 2 months ago

This post summarizes the tutorials I created in the past about Teradata. It is trying to help you gain the basic SQL skills with Teradata especially if you are a new beginner or you just move from SQL Server or Oracle. It also includes some guides about setting up your own Teradata server (latest Teradata Express version TDExpress16.10.00.03_Sles11_40GB.7z).

View detail

Setup Teradata in Microsoft Azure

23 views 0 comments posted at about 2 months ago

This page provides the steps to create a Teradata database in Microsoft cloud computing platform Azure.

View detail

Teradata SQL Tricks for SQL Server/Oracle Developers

44 views 0 comments posted at about 2 months ago

For many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. For example, how to select from dummy table or local defined variables. This page summarize the equivalents in Teradata SQL.

View detail

Teradata Tutorial – DateTime Related Functions and Examples

47 views 0 comments posted at about 2 months ago

This post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.

View detail

Logging configuration in .NET core

40 views 0 comments posted at about 2 months ago

.NET core introduces a logging API that works with a number of logging frameworks. The built-in providers are configurable and extensible to support different level loggings.

View detail

Retrieve Identity username, email and other information in ASP.NET Core

25 views 0 comments posted at about 2 months ago

The identity system in ASP.NET has evolved over time. If you are using ASP.NET Core, you probably found User property is an instance of ClaimsPrincipal in Controller or Razor views. Thus to retrieve the information, you need to utilize the claims.

View detail

Sending Emails in .NET Core Applications

84 views 0 comments posted at about 2 months ago

Sending emails are common in applications. For example, when user registers, we need to send account activation emails. This post summarize the approaches we can use to send emails in .NET Core 1.x and 2.x.

View detail

Retrieve Azure AppSettings and Connection String Settings in ASP.NET Core Apps

86 views 0 comments posted at about 3 months ago

In ASP.NET Core, we can easily use user secrets to manage our password or credentials. This post will summarize the approaches we can use after the websites are deployed into Azure.

View detail

Endpoints in AspNetCore.XmlRpc Explained

23 views 0 comments posted at about 2 months ago

There are four endpoints exposed by the middleware: summary, RSD, manifest for blog capability and RPC call main endpoint.

View detail

How to Use AspNetCore.XmlRpc

65 views 0 comments posted at about 2 months ago

This post provides the detailed steps about how to use AspNetCore.XmlRpc in your .net core projects.

View detail

Server.MapPath Equivalent in ASP.NET Core 2

246 views 0 comments posted at about 3 months ago

In traditional asp.net applications, Server.MapPath is commonly used to generate absolute path in the web server. However, this has been removed from ASP.NET Core. So what is the equivalent way of doing it?

View detail

XML-RPC Library for ASP.NET Core 2.0

114 views 0 comments posted at about 3 months ago

This is my first contribution in open source world. It is forked from XmlRpcMvc project in Github.

View detail

OpenIddict Refresh Token Flow issue ASP.NET Core 2.0

249 views 0 comments posted at about 4 months ago

View detail

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

24973 views 7 comments posted at about 3 years ago

View detail

Create ETL Project with Teradata through SSIS

6393 views 2 comments posted at about 3 years ago

View detail

Connect to Teradata Virtual Machine Guest from Windows Host

4471 views 16 comments posted at about 3 years ago

View detail

[C#] Connect to Teradata Database via .NET Data Provider

3339 views 2 comments posted at about 3 years ago

View detail

Resolve the Issues in Upgrading Entity Framework to Version 6.1

3026 views 0 comments posted at about 3 years ago

View detail

Querying Teradata and SQL Server - Tutorial 0: Preparation

2294 views 0 comments posted at about 3 years ago

View detail

Surface RT/Pro 版本Windows 8 QQ下载与安装

2221 views 0 comments posted at about 4 years ago

Surface的用户可能会遇到一个难题,在应用商城里边无法搜索到QQ应用程序。但是让我疑惑的是,我的Windows 8.1 系统之前是成功安装了QQ。

后来在腾讯QQ下载官网发现,其实是有QQ应用安装的链接:

按照如下方法安装Surface QQ.

Have fun!

image

View detail

Create and Debug C/C++ Programs with Eclipse and Cygwin in Windows

1988 views 0 comments posted at about 2 years ago

View detail

John about 4 days ago

Thanks for taking time to post this! That saved a lot of time!

Raymond about 2 months ago

@Brian Daves You are welcome. It is probably because Edge has no such issue and eventually it will replace IE.

Brian Daves about 2 months ago

Thanks for the help. That was a very annoying issue and I'm surprised it hasn't been fixed by the Core team.

Raymond about 3 months ago

Just a quick update:

The same installation steps are still applied to the latest version 16.10.00.03

TDExpress16.10.00.03_Sles11_40GB.7z

Raymond about 3 months ago

@Michael

https://github.com/aspnet/Identity/blob/dev/src/Microsoft.Extensions.Identity.Core/RoleManager.cs

The default query doesn’t include property Users as it is extended by us. Thus, you can write your own Linq query to use entity framework core extension method Include(r=>r.Users) to ensure Users are also loaded.

 In this way, the query generated will be a join SQL.


Raymond about 3 months ago

@Sasi Kumar

Apologies  for the late reply.

You can pass variables as you can do with any database, I.e. use variable expressions to prepare the statement.

Raymond about 3 months ago

@Mahe I could not identify any issue with your query directly.

Is your connection using the same credential as you were using in SQL Assistant?

Michael about 3 months ago

Hello, I've followed your suggestions above but still can't get out how many users that are assigned to a Role. I get: System.Data.SqlClient.SqlException: 'Invalid column name 'ApplicationRoleId'.' when I'm executing following: model = roleManager.Roles.Select(r => new ApplicationRoleListViewModel { Id = r.Id, Name = r.Name, NumberOfUsers = r.Users.Count() }).ToList(); Do you have some ideas on what I have done wrong? Thanks, Michael.

Mahe about 3 months ago

The alignment is all messed up in the comments. Sorry about that. BTW, its a VIEW select and not a TABLE

Mahe about 3 months ago

Hello, I am having trouble using JPA to run Teradata queries. I am able to run the generated query in SQL Assistant but not from JPA. Below is the exception. com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=UY_DEV_DATA.EQ_EV_H, DRIVER=3.62.56 select equipevent0_.EQ_IN as EQ_INIT_1_13_, equipevent0_.EV_DT as EVENT_DT2_13_, equipevent0_.EV_TM as EVENT_TM3_13_, equipevent0_.EV_TYPE as EVENT_TY4_13_, equipevent0_.WB_N as WB_SN5_13_, equipevent0_.CI_NA_19 as CITY_NAM6_13_, equipevent0_.LO_EY as LOAD_EMP7_13_, equipevent0_.R_BL_TM_RD as RPT_BLK_8_13_, equipevent0_.SP as SPLC9_13_, equipevent0_.ST_PR_IN as STATE_P10_13_, equipevent0_.TR_B_N as TRANS_W11_13_ from UY_DEV_DATA.EQ_EV_H equipevent0_ where equipevent0_.EQ_IN = 'ABCD123456' and equipevent0_.WB_N = '654654' The query runs successfully in SQL Assist and the schema.table is valid too. Can you please help ? Thanks, Mahe

Kevin Hodgkins about 4 months ago

This solution works great for me on SPA Templates. The new templates with vs2017 15.3 core 2.0 the file is now named boot.browser.ts

Sasi Kumar about 5 months ago

How to pass user variables in the query.

prat about 7 months ago

Very well explained. Thank you so much.