C# EF: How to search between two dates in EF but want to exclude time from data

i do not know how to execlude time from data when doing comparison in EF. ``` using (var db = new DbContext()) { var query = from n in db.BDatas orderby n.AddDate,n.Co...

8 Feb at 12:8

How to compare different branches in Visual Studio Code

How do I compare two different branches in Visual Studio Code? Is it possible?

18 May at 16:7

C# Print list of string array

How do I print a list of string arrays? I can do it from `string[]` using `Console.WriteLine`, but if I do that for a list with `foreach` it just prints out `System.String[]`. How do I write an index ...

3 Jul at 20:54

How to get the IME layout in C# Winform specially in Wndproc?

I have a winform application, I want to get the information of current typing language in C#. I have windows 10 machine, I have selected Korean language. There is one toggle button in taskbar to chang...

22 Feb at 05:50

Calling Node.js from C# .NET

Is it possible to call Node.js functions from a C# ASP.NET server? I found the Edge.js library, but as I understood, it allows Node.js to call into C#. I need the directly reverse solution.

25 Oct at 17:30

How to implement using statement in powershell?

How can I write using in power shell ? This is working example in C# ``` using (var conn = new SqlConnection(connString)) { Console.WriteLine("InUsing"); } ``` I need same in Powershell (not w...

8 Feb at 08:14

What is the first argument in a parameterless constructor?

I have simple program like this: ``` public class Foo { public Foo() { } public int MyInt { get; set; } = 10; public List<int> MyList { get; set; } = new List<int>(); } public cl...

8 Feb at 11:20

Unnecessary conversion to bigint

I have employee table with `bigint` primary key field in database and entity data model with database first approach. Employee class have this structure ``` public partial class Employee { publi...

ASP.NET core, change default redirect for unauthorized

I am attempting to redirect to a different login url in ASP.NET MVC6 My account controller login method has a `Route` attribute to change the url. ``` [HttpGet] [AllowAnonymous] [Route("login")] pub...

ServiceStack.Redis v3 and multiple hosts - recommended architecture

We are experiencing an issue where multiple instances of `RedisMqServer` are tripping up over each other - stopping one server stops the others. Clearly the way we have implemented this is wrong, but ...

Using Antiforgery in ASP.NET Core and got error - the antiforgery token could not be decrypted

My ASP.Net Core MVC application have added middleware like below: ``` services.AddMvc(); services.AddSession(); services.AddCaching(); services.AddSession(o => { o.IdleTimeout = TimeSpan.FromMinut...

Using DataTable in .NET Core

I have a stored procedure in SQL Server that accepts a User-Defined Table Type. I'm following the answer from this post [Bulk insert from C# list into SQL Server into multiple tables with foreign key ...

XAML Designer displays property name instead of Designer Data (d:DataContext) when Binding

### Context I want my `UserControl` (`RepositoryContainer`) to be filled up with data when on XAML Designer. I created a file named `RepositoryContainerDesignData.xaml` (it is in the same folder ...

23 May at 12:17

Execute multiple policies

How to execute multiple policies (or combine them into a single one)? For example I have: ``` var policy1 = Policy.Handle<DivideByZeroException>().WaitAndRetry(5)); var policy2 = Policy.Handle<StackO...

31 Jan at 09:10

Expose docker container port to other machine

I have installed Redis in Docker using below command ``` docker run -d -p 6379:6379 redis:3.0.1 docker run -d -p 6380:6379 redis:2.8.20 ``` Now I need to access this redis instance from another mac...

7 Feb at 11:43

Execute Set of ValidationRule-C# Class Design - Better Approach

I have a case there I need to execute set of validation rules for different companies. There will be multiple validation rules against one Company. So I have following table Structure ...

12 Feb at 02:50

MVC 4: How to maintain sessions and cookies to be still valid after IIS restart?

It seems that my login session (using simple membership) and cookies (verification token) are not valid after IIS server restart. This is a problem for me, if a user in the middle of a transaction the...

22 Feb at 15:52

C# generic method resolution fails with an ambiguous call error

Suppose I have defined two unrelated types and two extension methods with the same signature but different type filters: ``` public class Foo {} public class Bar {} public static class FooExtensions...

Servicestack - Google authentication error

I'm getting the following error when when trying to make login with a google account in production environment: ``` 2017-02-06 10:34:26.8978|DEBUG|HttpResponseExtensionsInternal|Setting Custom HTTP H...

6 Feb at 22:25

Recurring jobs with Hangfire and Asp.Net Core

I have serivce which has some method which I would like to be Recurring job. I know that I can use hangfire in my Startup.cs e.g: ``` RecurringJob.AddOrUpdate(() => Console.WriteLine("I'm a recurrin...

Switch between dotnet core SDK versions

I recently installed VS 2017 RC and then automatically my dotnet version pointed to `1.0.0-preview4-004233`. Due to that whenever I create a new project using command `dotnet new -t Console` I cannot ...

26 Feb at 08:28

How to open a System.Data.SQLClient.SQLConnection with Active Directory Universal Authentication

I was using the below code to connect to SQL Azure DB that was using Active Directory Integrated Authentication. ``` private string GenerateConnectionString(string databaseName, string serverName) { ...

Read smart card on demand

I am making an application in which a user would see a login page, enter his email address and a password. At that time I want the system to read his CAC certificates and permit him to choose. Right...

6 Feb at 15:22

Best way to use HTTPClient in ASP.Net Core as a DI Singleton

I am trying to figure out how to best use the HttpClient class in ASP.Net Core. According to the documentation and several articles, the class is best instantiated once for the lifetime of the applic...

10 Dec at 23:53

Confused about Directory.GetFiles

I've read the docs about the `Directory.GetPath` search pattern and how it is used, because I noticed that `*.dll` finds both `test.dll` and `test.dll_20170206`. That behavior is documented Now, I ha...

6 Feb at 09:35