.status-msg-wrap { display: none; }
Monday, December 31, 2018
no image

Coming from having done a few projects in Java/Spring Boot/BIRT Reporting over the years, I'm looking for seasoned advice as I'm delving into a .NET Core project. Razor vs React and a solid Reporting tool, or solution that would fit nicely.

The client wants to stick to the. NET ecosystem. Having done a number of ASP.NET MVC / WebApi projects in the past. This is my first .NET Core app. This is a small to medium internal app, for up to 50 or so concurrent users.

I'm thinking of using React for the view (maybe just stick with Razor Views?), .NET Core for the controllers/backend/database access (of course). However, there isn't a clear path to implement reports. I can't use an SSRS Server/Services for this, and other reporting solutions for .NET seems to jump off SSRS or cost quite a bit for just a single license (DevExpress, Syncfusion etc).

BIRT Reporting was great with Java .. open source and fairly intuitive and got the job done nicely and quickly. Write your SQL query and drop the report control into your page.

Any advice or suggestions would be great on the overall above!

Coming from having done a few projects in Java/Spring Boot/BIRT Reporting over the years, I'm looking for seasoned advice as I'm delving into a .NET Core project. Razor vs React and a solid Reporting tool, or solution that would fit nicely. Click here
no image

ASP.NET Core and C#. The hidden gem in plain sight.

I am mainly a full stack JS developer, usually using technologies such as React for front-end and Node (Express Framework for Web Servers) for back-end. Recently I have been doing a ton of research on all things C#, messing with unity, xamarin, building mvc apps, razor page sites, web api's, watching latest conventions, panels, reading articles etc....

It seems to me so far that microsoft are actually doing an excellent job! The new platform seems to be very performant, it's cross platform of course too, great support as it's backed by microsoft, strong security, C# is strongly typed so we have advantages there, has async support...

It usually takes a long time for technologies to catch on, usually 3+ years. I'm almost wondering do we have a hidden gem here. It seems to me this is beating out over other technologies right now. Perhaps for a small business (or maybe even prototypes) then something like a small JS or PHP app may be better, however I am thinking still now with these changes, the benefits may out weigh any extra costs that there "May" be. (from what I have read, though maybe old news, dotnet apps can cost a little more and are usually used more often for enterprise similarly to Java).

This probably sounds like I am very biased toward Microsoft with C# and ASP.NET Core here, however, I am just pretty impressed so far by both the C# language and ASP.NET Core platform. I feel like if Microsoft carry on with support (it seems great already but I am just a beginner, perhaps there are some caveats), this platform should be growing at a great pace, building apps with this platform seems to provide a lot of positives right now.

What are your thoughts on the state of C# language and ASP.NET Core right now? Also any thoughts on Entity Framework Core and Identity would be most welcome too. Particularly from experienced .NET developers.

Cheers!

ASP.NET Core and C#. The hidden gem in plain sight. Click here
Sunday, December 30, 2018
no image

Can’t add Entity framework in items?

I’m trying to practice using EF by modeling a basic database locally.

My understanding is that I just need entity framework nugget package installed and sql server data tools for visual studio installed. When I right click on the project and add item, there is nothing there for entity framework. Just basic options for adding a class, text file, etc.

I’m using visual studio 2017 community. What am I missing here?

I’ve tried reinstalling many times and I can’t get it to pop up. I’ve tried with an mvc asp.net (.net framework) application and also a console app of the same.

Nothing I’ve looked up online works.

Can’t add Entity framework in items? Click here
no image

Question about how to best handle sub-dependency updates on libraries

I am making progress on v2.0 of my CMS, and a lot of it will be about extensibility and expanding the architecture, but I have run across a scenario I can't find too much info on. I wanted to try and test out some options, but the process of releasing packages to test it over and over again was pretty painful.

A quick piece of background and the end goal: One of the features I am hoping to have in the next version is support for 3 different datastores. As I use more third party libraries to interact with other data stores, it made since to have difference packages for each store type (LiteDB, vs Postgres, etc) but would want the library that manages and renders the CMS (Spoon-Web) to be independent and be updated. Using the Postgres Spoon Driver as an example, it would have the package they install (Spoon-Postgres), Marten as the library to interact with the database, and Spoon-Web to power CMS admin, and define interfaces...

 ----------------------- | Spoon-Postgres | ----------------------- | - - - - - - - - | | ----------- ----------- | Spoon-Web | | Marten | ----------- ----------- 

What I would like to be able to define is that Spoon-Postgres will stay on v1.2, Marten will be v3.2, and Spoon-Web is v2.0. But in the future, I may want to release an updated version of Spoon-Web, say 2.1, that WILL update through nuget in a projects dependencies without requiring an update to Spoon-Postgres v1.2, but also define that Marten would NOT update past v3.2 without a new release of Spoon-Postgres.

I see a lot of options in the docs around configuration and such, and many parts of it seems to be in web projects and not libraries, and this use case is not clearly defined from what I can see. Does anyone have any experience managing something like this and where I could clearly define it? I know some of this may be convoluted to read, but hopefully it made sense.

Any help would be hot, thanks.

Question about how to best handle sub-dependency updates on libraries Click here
no image

Getting 401 Unauthorized for files in wwwroot on refresh.

I'm trying to solve this issue for a couple of days now, but I can't manage to do it, so I would really appreciate the help.

I've done a course for webapp in ASP.NET Core 2.1 WebAPI and Angular 6, using JWT Tokens as a form of authentication. I want to publish the app, but currently I came across a problem which instructor didn't have, I assume because he published first, then changed the project, meanwhile I looked updated version, so I did changes first and then tried to publish.

Anyway, thing is, when I run WebAPI and Angular server using "ng serve" everything works fine. I used "ng build", set a path to be "wwwroot" folder in API project and I got necessary files. After that I added these lines to Startup.cs:

app.UseDefaultFiles(); app.UseStaticFiles(); app.UseMvc(routes => { routes.MapSpaFallbackRoute( name: "spa-fallback", defaults: new { controller = "Fallback", action = "Index" } ); }); 

and added new file Fallback.cs:

public class Fallback : Controller { public IActionResult Index() { return PhysicalFile(Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "index.html"), "text/HTML"); } } 

When I run API, I get to homepage, after login, everything works fine. I can navigate to localhost:5000/members and get the members. The problem is when I press the refresh button for example on this members page. Doesn't matter where I am in the app, as soon as I refresh, the page becomes blank. I've checked requests and headers and noticed that it's always 401 Unauthorized, I guess because "WWW-Authenticate: Bearer " is without the JWT token itself.

Can someone tell me what am I missing and how to fix this?

When I navigate to localhost:5000/members after login, for the request I see 200 OK and URL http://localhost:5000/api/users?pageNumber=1&pageSize=5, meanwhile after I refresh, I see the URL is localhost:5000/members with 401 Unauthorized. Also, I tried sending request to localhost:5000/members in Postman, but adding Authorization header with "Bearer tokenhere" as well and I get this which are the files from wwwroot folder and 200 OK.

I assume Kestrel somehow doesn't understand how to navigate localhost:5000/members to Index action of Fallback controller, because when I use Postman, I hit breakpoint I set on Index action in Fallback.cs, hence why I get those files showed in the picture.

This is my Startup.cs.

AuthController where I generate token in login method.

UsersController

Getting 401 Unauthorized for files in wwwroot on refresh. Click here
no image

Is it possible to develop Android app with Xamarin on Linux?

Some time ago there was a straight no answer to developing Xamarin Android apps on Linux. Has something changed since then? Is it possible to develop Xamarin apps on Linux now? I managed to install latest MonoDevelop and Mono framework on my Linux Mint box, but I can't figure out how should I install Xamarin libraries and compile code for Android if it is even possible.

Is it possible to develop Android app with Xamarin on Linux? Click here
no image

Question about my personal portfolio as a software developer!

How do I come up with ideas to applications to my portfolio to impress people? Like as a software, all of the ideas are taken and done like great apps. I've started to work on my portfolio in hope to get a job in the near future but it's just crazy I can't move on. I know how to code but what do code? I don't want to put simple ideas in my portfolio idk man

Question about my personal portfolio as a software developer! Click here
no image

MVC5 image upload & preview

Hi,

I am new to MVC. I would like to make a web site which user can upload an image and preview it. Is there any tutorial that I can use?

Best Regards.

MVC5 image upload & preview Click here
Saturday, December 29, 2018
no image

Foreign Key and fetching it from the database (EF Core)

Alright, so I have a 'Users' table with a foreign key called 'Key'.

In the model I have:

public Key Key { get; set; }

this works when I create a new user and the KeyId is properly set for the added user.

However, when fetching a user:

_context.Users.FindAsync(userId);

Key is null. Why and how do I fix this?

Foreign Key and fetching it from the database (EF Core) Click here
no image

What's the state of Mac desktop applications with .NET?

Let's say I wanted to build a cross platform (Windows/OSX) application with dotnet. Is this something that's realistic and possible in 2018, or is it still a utopian dream?

I haven't used dotnet in over a decade so I'm way out of the loop. Which gui framework should I be using?

Just hoping not to have to use Java!

What's the state of Mac desktop applications with .NET? Click here
no image

When is the Authentication cookie bound to the current authenticated user and How does the bind happen?

Hey guys, so I'm working on an asp.net web application and I'm having trouble figuring out:

1.) When is the Authentication cookie bound to the current authenticated user?

2.) How does the bind happen?

Though it works, I find it weird that the (Login method), accessible via (// POST: /Account/Login) does not in anyway bind the Authenticated user to the Cookie after confirming that the user exists in the database.

Can anyone give a simple and easy to understand explanation why this is the case!!! Haven't found any good documentation yet after a sleepless night

I'm using the default [ASP.NET Web Application(.NET Framework)] template,

Here is the configure sign in cookie, 

app.UseCookieAuthentication(new CookieAuthenticationOptions

{

AuthenticationType = DefaultAuthenticationTypes.ApplicationCookie,

LoginPath = new PathString("/Account/Login"),

Provider = new CookieAuthenticationProvider

{

// Enables the application to validate the security stamp when the user logs in.

// This is a security feature which is used when you change a password or add an external login to your account.

OnValidateIdentity = SecurityStampValidator.OnValidateIdentity<ApplicationUserManager, ApplicationUser>(

validateInterval: TimeSpan.FromMinutes(1),

regenerateIdentity: (manager, user) => user.GenerateUserIdentityAsync(manager))

},

SlidingExpiration = false,

ExpireTimeSpan = TimeSpan.FromMinutes(2)

});

And here is the Login post form which confirms and authenticates a user with no cookie reference 

// POST: /Account/Login

[HttpPost]

[AllowAnonymous]

[ValidateAntiForgeryToken]

public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)

{

if (!ModelState.IsValid)

{

return View(model);

}

// This doesn't count login failures towards account lockout

// To enable password failures to trigger account lockout, change to shouldLockout: true

var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);

switch (result)

{

case SignInStatus.Success:

return RedirectToLocal(returnUrl);

case SignInStatus.LockedOut:

return View("Lockout");

case SignInStatus.RequiresVerification:

return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });

case SignInStatus.Failure:

default:

ModelState.AddModelError("", "Invalid login attempt.");

return View(model);

}

}

When is the Authentication cookie bound to the current authenticated user and How does the bind happen? Click here
no image

Where to start?

Hey guys, here;s where I'm at.

20 years in the IT industry, majority Windows Admin/Server stuff. Have recently gotten the bug to want to break out and see if I can be a decent developer. As I want to stick in the Windows world, have been learning C# as a start, but I really want to move into Web Design/Development.

Now being MS that don't make it easy :) I seem to have come at a time where MS is at a crossroads with .NET, just trying to get a handle on things here. I see asp.net core, .net core. Then I see .net framework. is .net framework technically asp.net core? From my research it seems .net core is where everything is heading but not fully mature with regards to I guess having all the same capabilities as .net framework/asp,net core?

Am I looking at this the right way? So I guess I'm wondering what path should I take so I'm not learning old tech at 46 lol Just to be outdated. Not looking to work for a company to maintain old code etc as I work for myself. New startup stuff etc. Yeah I know It's kind of a ramble. Hope it makes sense.

Regards,

Joe W

Where to start? Click here
Friday, December 28, 2018
no image

looking for some refactoring suggestions from veterans

Our team needs to add a new line of business to our existing system and have a somewhat short deadline (2ish months).

Unfortunately like any 15+ year system, it wasn't really written with the understanding that a new line could be added.

Essentially, we've got an overgrown LoanQuote class and an overgrown LoanAccount class that represent bank loans.

The new line of business still involves the concept of loan quotes and loan accounts, yet the properties, processes, and calculations are very different.

I've taken like four different stabs at breaking it apart and I'm not sure which strategy I should pull the trigger on and commit.

I've tried:

  1. Refactoring the original line of business behavior into a Strategy so I could reuse the LoanQuote class with different strategies for each line of business. I found that the LoanQuote class is so heavily permeated with behavior from the original line of business that it would still be a mess.

  2. Creating a base class that only contains the shared properties between line of business. The base class really only handles saving and loading. I'd be sharing the DB tables so the table would have to contain the properties from both line of businesses. Same as option 1. The existing application would continue working just by instantiating the inherited original line of business subclass. I'd need new UI that would deal with the subclass of the new line of business.

  3. Avoiding the original line of business code entirely, no inheritance, no composition, just new classes, new storage, sort of like DDD bounded context. It lives in the same codebase, shares some entities, but needs a lot of new UI and new tables.

It's overwhelming because I've never had to do something like this. I'd really like to reuse the quote and account classes because they are the primary objects in the system, but I'm concerned mixing them via inheritance is just going to make a bigger ball of mud.

Has anyone had a similar experience? With a 2 month deadline? How did you handle it?

looking for some refactoring suggestions from veterans Click here
no image

References, how do they work?!?

I've been a .Net developer for 12 years now, and I feel very senior with almost all aspects of creating, debugging, and deploying applications that I've come across. But any time I run into a reference issue, I feel like I'm a brand new developer, and it takes me at least a day to get back on track...

I am pretty comfortable using NuGet, and I can usually get things sorted out pretty quickly when packages are added through that. But when they aren't, I have basically 0 clue as to how things are actually linked and loaded.

I see all this stuff about "Copy Local", path hints in the project file, version numbers in the web.config, and if it's a global assembly or not, but none of it makes sense to me. I guess I'm looking for something that just describes best practices and maybe good steps to troubleshooting and cleaning up issues. I just hate wasting time on that sort of thing, since it's not productive or interesting work.

For example / rant, the software I work in (I'm the only developer) uses an older version of Crystal Reports. I created a new branch to start working on a new report, and decided to delete the existing references, and just add them through NuGet to get newer versions and clean things up. Took me a little bit of fumbling around to make sure all the projects were synced up, but it wasn't a huge issue. I was having issues testing the old reports, so I went to revert back to the old Crystal Reports, but it was bitching about not finding that version... I decided to switch back to my (unchanged) develop branch, and still the same issues! It's like there were missing references that maybe weren't tracked or something? I had to manually set the version in the project file just to get it back to the way it was. /rant

Even though that problem is solved (for now), I feel like I'm missing something basic with understanding how to manage this stuff.

References, how do they work?!? Click here
no image

Client App for capturing scan input and integrating with local Zebra Printer

Hello, I am considering the various options for creating a client app that a warehouse user would use which can accept scan input and will be sending data to a local Zebra printer for printing shipping labels. My initial thought is to put together a WinForms app for this, but I am wondering if there are better options that anyone knows of or any caveats to using a WinForms app for this. Appreciate all of your feedback, thank you!

Client App for capturing scan input and integrating with local Zebra Printer Click here
no image

Question on how to scale SQL Server from Monolithic to high availability for a high demand/ multi/micro service system.

Hi all,

I'm not 100% sure where is the correct place to ask this question, so please forgive/enlighten me if you has seen this question repeated some where.

Let me first start this, by give a clear context on where our system currently is and what are the issue:

  1. The system purpose: We developing a platform for multi-tenant user to use our platform to manage their business processing. (Mostly doing ERP tasks...)

  2. The system design: We have a monolithic design web site/app with:

  • One SQL Server database (to store all system wide data)
  • One web server (to provide web APIs)
  • One website (light front-end)
  • Several workers/services implemented on C# .NET
  1. The implementation:
  • All back-end APIs and worker are access database via Entity Framework (6.0) - Database first.
  • Each worker service run in cycle 1 minutes, and once it run, it can process a long-period transaction with requires saving multiple times on multiple entities.
  1. The issues:
  • Poor query performance (nearly 10 sec for a query listing on a table with join 2 tables, each table has about several thousands records). I know Entity Framework is slow, but is it really this bad? :(
  • We constantly run in to time out issue.
  • We got concurrency exception (Although, logically we can assure that there's no change was made while a worker service is processing an entity object)

Giving the issue, I would like to ask that:

  1. Giving our system design, what is the main cause of the poor performance: SQL Server or Entity Framework?
  2. I don't have experience in DevOps and SQL Scaling. Given our situation, what is the "TODAY" strategy to scale SQL Server (horizontal) to handle much more query demand, remove the outage and get highest availability for our system?
  3. In the mean time, we planned to improve the performance first by indexing, review and remove logic which use long-holding transaction. But giving the dynamic of Entity framework, we not sure we should take this part, or move completely to other ORM (like Dapper)?
  4. I also researching and plan to redesign our system to use micro service architecture, but one thing that I still not completely understand is that: Although, we break the database into multiple domain-driven instance. But then, it will can also be run into the same problem again if the domain is big enough. I know some system use No-SQL, in-memory db like Redis, and other db like MongoDb when I come to high scalability system/ micro service. This make me wonder: Does SQL Server Database really suitable for micro services? Will I run into the same issue again when the domain for each service is big enough? Or are there any solution/strategy that modern system apply to make SQL Server really suitable for micro service architecture.

TL;DR: We have a monolithic system which recently run into poor performance issue. We tried to fix it with indexing, logic etc...and one thing we know for sure that we have to apply micro-service architecture. But one question still remain: The bottle neck still remain at our database server (SQL Server), how could we actually scale SQL Server so our system really becomes high available and suitable for high demand, high availability system?

Question on how to scale SQL Server from Monolithic to high availability for a high demand/ multi/micro service system. Click here
no image

Live Documenter now open source on GitHub (.NET Documentation Generator)

I created a .NET documentation tool a few years ago under a company Box Software. It allowed viewing of live documentation from .NET solutions/projects and libraries as well as exporting XML comments to web/CHM and other formats.

I have now released this code in GitHub (https://github.com/barry-jones/live-documenter) and I am currently working on converting it to .net core.

It is already a fully functional product. So if you are looking to be able to generate CHM files or MSDN style web documentation for .NET projects it is already everything you need.

I am still working on getting some of the content across from the original sites which are no longer available, but a little more information can be found here (http://livedocumenter.barryjones.me.uk/).

Live Documenter now open source on GitHub (.NET Documentation Generator) Click here
no image

How to add package and package dependencies with dotnet CLI?

So I'm trying to use VS Code to do development with dotnet CLI and while adding EF core and building I keep getting errors because I needed to explicitly dotnet add the dependencies. Is there anyway to add the package and it's dependencies?

How to add package and package dependencies with dotnet CLI? Click here
no image

Need advice on creating an installer

My work has tasked me with the job of creating an installer for our software suite. The lead said I cannot use third party tools like WiX, Advanced Installer, etc. He wants a nice modern looking installer. What would be the best way to go about this? Create it in WinForms or WPF? Most of our codebase is in .NET 4.0. I was just gonna start winging it but I figurd I'd ask first.

Sorry if this is a strange question. I was planning on going through a WiX project but 2 days into working on it he said I couldn't use WiX and I don't really know how to do this from scratch. I've tried searching google but most results show up as installing a microsoft technology like WPF or WinForms instead of using it to create an installer. Any links / feedback would be helpful!

Need advice on creating an installer Click here
Thursday, December 27, 2018
no image

Asp.net Core MVC and loading gifs on button click

I've been looking all over the bings for a good way to do a loading gif on button click, and the AJAX stuff is very confusing to me. I'm new with MVC / .net Core coming from webforms, so I never did any ajax stuff before (and I'm not a real web developer at all).

What I currently have in my view is a button that does this:

 <input type="submit" a class="btn btn-outline-primary" value="Transfer" formaction="Transfer" /> 

Then I have another button for a cancel command:

 <input type="submit" a class="btn btn-outline-danger" value="Cancel" formaction="Cancel_Transfer" /> 

In my controller I then have a this for handling the button click:

 [HttpPost] public IActionResult Transfer() { ///Does a bunch of stuff that works right but takes a really long time } 

And theres a respective Cancel_Transfer method that works correctly as well. The issue I'm having a hard time wrapping my head around is how to get the submit button click interecepted by Ajax to turn on a loading gif, then pass on the formaction command. Ajax super confuses me, so I'm sure its just me, but if anyone could help me break this down it'd be super appreciated.

Asp.net Core MVC and loading gifs on button click Click here
no image

What is "in-process hosting" and why do I want it?

I just updated my asp.net core project to 2.2 and there is a lot of mention about in-process hosting.

I had a brief look at the docs but they were too in-depth.

Can anyone give me the tl;dr of what it is?

What is "in-process hosting" and why do I want it? Click here
no image

Cookies with IE11

Hey guys,

Currently building an internal .net core web application that uses cookies to send a user's role to the client. Everything works fine while using chrome, the browser saves the cookie. Today, I decided to check if my project works in IE11 to find out that the cookie is not saved at all.

if (!httpContext.Request.Cookies.Keys.Contains("Role")) { CookieOptions option = new CookieOptions(); option.Expires = DateTime.Now.AddHours(3); var user = httpContext.User.Identity.Name; var role = roleRepository.Get(userRepository.Get(user).RoleID).Value; httpContext.Response.Cookies.Append("Role", role, option); } // blah blah 

This is the segment that actually creates the cookie and then appends it to the pipeline. Once again, in chrome everything works fine but in IE11 it's not registering the cookie at all.

I did some research and many mentioned about domains with underscores but I'm developing on localhost so I'm not all too sure if that's an issue.

Thanks in advance!

Cookies with IE11 Click here
no image

Recommendations for good free/opensource asp.net business intelligence offerings?

I was wondering if anyone had any recommendations for what's ostensibly, a free version alternative of Sql Server Reporting Services, or some general (and hopefully 100% web based) business intelligence software built in .NET/C# ? I've tried googling, and most of what I've come across is dead and gone, or has turned commercial. I'm trying to avoid having to re-invent the wheel, with building the UIs for a "diy" report builder-- list the tables, list the columns, list possible aggregate options, drag and drop, etc, etc.

Recommendations for good free/opensource asp.net business intelligence offerings? Click here
Wednesday, December 26, 2018
no image

MCSA: Web Applications - what does it really take to get this certification?

My employer is requiring that I earn my MCSA certification in order to work with a .net-based CMS we are currently having implemented. This year, an outside company was hired to do the initial implementation but eventually I am expected to be the main developer for my organization as far as maintaining the CMS and implementing new sites and features.

I believe I can pass the 70-480 exam (Programming in HTML5 with JavaScript and CSS3) within the next couple of months but it's 70-486 exam (Developing ASP.NET MVC Web Applications) that I am worried about.

I was told to study for the MCSA over the course of 2018 but I have had to spend 90% of my time putting out fires (and I'm the only person on my team with the skills to do so) and developing scripts to assist with the migration to this new CMS.

And the description for exam 70-486 states:

"This exam is intended for developers with a minimum of three to five years of experience developing Microsoft ASP.NET web applications, including two or more years developing MVC-based solutions."

Link: https://www.microsoft.com/en-us/learning/mcsa-web-applications-certification.aspx

Needless to say, I have not learned .NET anywhere even close to being ready for the 70-486 exam. And even if I had not had to put out so many fires, the above description suggests that it would be unrealistic for someone brand new to .net to become certified in one year.

My employer is now paying me really well (recently got a big promotion) and I want to see this project succeed.

That said, if you have your MCSA for web applications, do you think it really takes 3-5 years of experience to pass this exam?

There is such a variety between developers as far as prior programming experience, amount of free time, IQ, and work ethic, that I think it would be pretty hard for Microsoft to put a number on how many years of experience you should have before being ready for the exam. So I want to believe that it would be possible to pass in fewer than three years of working with .net.

The managers in charge of this project obviously did not see this "three to five years of experience" figure on the exam page and frankly I didn't want to point this out at the start of 2018 for fear of them deciding to get rid of me. Of course, I also (arrogantly) felt that I would be a certified MCSA dev by end of 2018 despite what the exam page says.

As of now, I've managed to buy myself some more time - I told my manager there would be no certification by end of 2018 and we agreed to re-evaluate the situation at my mid-year evaluation in July. But that's only 7 months, and based on the dynamics of my team and that "three to five years" thing, I'm worried things are going to come to a head.

I can't help but feel like I'm making excuses if I say "hey, this is not realistic" but at the same time, based on how much work I need to do on top of getting ready for this certification it really does seem unrealistic - even studying on my own time.

As for my background, I've been programming primarily with PHP at an intermediate level for about three years now. I learned to program initially in college with Java, so C# has been fairly intuitive to learn so far. I am willing (and happy) to learn on my own time, but burn out has been a problem for me.

Any advice about passing the exam (not interested in brain dumps or any kind of cheating), or what to do in this situation, would be welcome.

MCSA: Web Applications - what does it really take to get this certification? Click here
no image

How can I create a local web server to host my SQL database for users can use my c# application without restritments

I made a c# application for my company to save various type of data of employee, meetings, etc. My application will go to multiple computers on the company and I need to have a database in a server so users can use all the same database. How can I achieve this? Thanks so much guys! PS: I used easyPHP to design my sql database

How can I create a local web server to host my SQL database for users can use my c# application without restritments Click here
no image

Warmup .netCore app

Hi all! I'm running some .netCore 2.2 microservice (using GRPC transport) and notice, that first request take 100x longer time, than others. I think it's because JIT compilation. What is the best way to solve this issue? How to warm up service on startup?

Warmup .netCore app Click here
no image

Coming from MVC 5 to asp.net core 2.1.. Add IdentityUser

As the topic says I'm creating a custom add user form. Password will be auto-generated so the only thing the user will submit is their e-mail.

In MVC5 there was a nice account controller. Not so much in core 2.1. Tried scaffolding some stuff and I got some files in Areas/Identity now but not getting any wiser.

How can I register these suckers and save them to the aspnetuser table in the database?

var user = new IdentityUser { UserName = model.Email, Email = model.Email };

var result = _userManager.CreateAsync(user, password);

No errors thrown on stepping through this but nothing is saved to the databse.

Coming from MVC 5 to asp.net core 2.1.. Add IdentityUser Click here
no image

Invitation to join a c# community

Hello! My name is Kaisinel and I am the owner of C# inn- community of over 1.3k developers. Our main goal is to help people get into programming and exchange knowledge. Right now, we're working on expanding our goals, turning the community into a place where people can learn and collaborate, all while having fun and making friends.

If you're looking for a place to ask questions, discuss anything tech related, have fun, get involved into a community or simply want to see what programming is like, this is the right place for you.

We promote working together, we organise both programming and social events. There are teachers, mentors and we recently started streaming lessons on Twitch. We care about our members a lot and we improve the community based on every suggestion made.

If you liked what you heard and got interested, feel free to join! Discord invite link: https://discord.gg/Bfme3PD

Thank you for reading this. Merry Christmas everyone 🙂

Invitation to join a c# community Click here
Tuesday, December 25, 2018
no image

Working with SQL CDC and EF Core code first?

Hi,

I need to create a project that stores structured data that many tables should be editable by the community.

I figured SQL Server Change Data Capture would be a very good solution to my doubt by enabling it on those tables.

My question is, what things should I consider when getting it to work with EF Core using the code-first approach, and whether this is possible at all.

Working with SQL CDC and EF Core code first? Click here
no image

Will https be activated once I deploy my app?

I've finished my app done in ASP.NET Core WebAPI and Angular 6 on frontend and I plan to put it in a docker container (or deploy straight away if I somehow fail with docker) and deploy it. Instructor I've been following, didn't do anything particular regarding https protocol and he even commented out

app.UseHsts(); app.UseHttpsRedirection(); 

in Startup.cs. After following his publishing section (he uploads to DO and azure), he ends up with http protocol on DO, but https on azure (I assume azure does that automatically). I've already bought domain name and SSL cert from namecheap (I know I could get it for free, but it was just $1) and I have DO acc and another VPS. My plan is to deploy on DO, but I'm not sure will SSL and https work straight away if I just point them out to deployed app, so I'm not sure do I have to change anything?

While I followed instructor, the whole app was under http, but I uncommented out above two lines, run API with

dotnet dev-certs https --trust 

but I still see "Your connection is not secure" on Firefox. Regardless, I tested API with Postman and it works, but Angular doesn't work, since it's only allow me to login, but can't retrieve the data, because I assume angular server is listening on http://localhost:4200/.

Do I have to do something like this on angular side or it will be automatically done once I do a production build?

Will https be activated once I deploy my app? Click here
Monday, December 24, 2018
no image

Is it worth learning EF as a database developer?

I started out my career as a database developer and it is still part of my core duties. As such, I'm extremely comfortable with writing SQL queries, stored procedures, optimizing and writing performant queries, ETC.

As such, I've been using Dapper and completely avoided EF altogether as it mostly confuses me. I can't figure out if there's a way to execute stored procedures or complicated table joins--it's straightforward with Dapper.

I've googled around and have found a lot of conflicting opinions. I've always gotten the best advice from reddit, so I thought it would be appropriate to re-ask the question here. Why should I learn it (beyond looking good on my resume)?

Thanks guys!

Is it worth learning EF as a database developer? Click here
The webdev Team