System.Data.Sqlclient for .NET Core

This is a quick tip for getting System.Data.Sqlclient for .NET Core console app.

When you look for EntityFramework in Nuget

clip_image002

then you will get the error “Package restore failed. Rolling back package changes for ‘ConAppNetCore’”.

Get the Microsoft.EntityFrameworkCore.

clip_image004

This one works for me.

Posted in .Net, Community, Computers and Internet | Tagged , , , , | Leave a comment

Update from Visual Studio 2017 15.0 to 15.2

The short blogs shows you one of the ways to upgrade from Visual Studio 2017 15.0 to 15.2.

Click on the small flag at your right top corner then you will see “Visual Studio Update” is available. Click on it.

clip_image001

 

When you see another dialog pop-up then click Update.

clip_image003

Then it will ask you to close your Visual Studio if you have not.

clip_image005

Once you close your Visual Studio 2017 then you can click Retry and your upgrade will start. It took me around 1 hour.

clip_image007

You can then launch your Visual Studio 2017 15.2.

clip_image009

 

It is Version 15.2 now.

clip_image010

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment

Shut down without update in Windows 10

Finally you can shut down your Windows 10 without Update.

clip_image001

But you need to have Windows 10 1703.

clip_image003

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment

Why use Java

Introduction

Java is an object-oriented programming language that was first released by Sun Microsystems in 1995.  Back in the 90s all the programming languages were not GUI friendly. The only GUI friendly programming language was Visual Basic. Again, back in the 90s Visual Basic did not have the capability to support full object-oriented feature such as Inheritance.

Cross-platform

Java is a portable language that can be executed through multiple platform compatible Java Virtual Machine (JVM). Furthermore, you can write code in Windows Operating System environment then deploy it onto the Linux Operating System environment.

In Mobile space

Java is also the native language used to develop the phone applications for Android Operating System. Android Operating System itself is also running on Java Runtime environment. For example, the Pokémon app that people are playing using Android mobile was developed using Java.

Easier to Maintain

Java is a statically-typed language. This means your code will have to be checked for errors before it can be compiled to become an application. In this way the syntax errors will be easier to identify. Since statically-typed languages such as Java are also more strict with the definitions of data members and member functions, you will have fewer surprises and unexpected errors, which means your codebase will be easier to maintain as it grows in size and complexity.

Summary

Java may not be the best language, depending on how you applied your programming language. With all the valid reasons mentioned above Java is going to stay for a decade or two. Oracle acquired Sun Microsystems in 2009. Java then became the primary language to build the Oracle stack, such as Oracle Fusion Middleware. As long as Oracle is doing well then Java will be useful. 

Posted in Community, Computers and Internet, Java | Tagged , , | Leave a comment

Oracle Provider for OLE DB User Name and Password grey out SSIS

This short blog let you know one of the possible reasons why the User Name and Password grey out in SSIS package.

clip_image002

This is because the Oracle Developer Tools for Visual Studio or ODAC. You can download it here  http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html.

Posted in Community, Computers and Internet, Oracle | Tagged , , | Leave a comment

Windows 7 cannot Windows Update

This short blogs show you how to update your Windows 7 since the Wanna Cry Ransomware is attacking badly at this time.

There are pretty of links out there but I remember this official one work for me.

Windows Update is taking an unusually long time to scan and install updates

https://support.microsoft.com/en-us/help/3200747/windows-update-is-taking-an-unusually-long-time-to-scan-and-install-updates

Download:

April 2015 servicing stack update for Windows 7 and Windows Server 2008 R2

x86: https://download.microsoft.com/download/c/0/8/c0823f43-bfe9-4147-9b0a-35769cbbe6b0/windows6.1-kb3020369-x86.msu

x64: https://download.microsoft.com/download/5/d/0/5d0821eb-a92d-4ca2-9020-ec41d56b074f/windows6.1-kb3020369-x64.msu

July 2016 update rollup for Windows 7 SP1 and Windows Server 2008 R2 SP1

x86: https://download.microsoft.com/download/c/d/5/cd5de7b2-e857-4bd4-aa9c-6b30c3e1735a/windows6.1-kb3172605-x86.msu

x64: https://download.microsoft.com/download/5/6/0/560504d4-f91a-4deb-867f-c713f7821374/windows6.1-kb3172605-x64.msu

Others:

https://www.cclonline.com/article/1799/Guide/Operating-Systems/Windows-7-Unable-to-Download-or-Install-Updates-from-Windows-Update/

http://helpdeskgeek.com/windows-7/cannot-run-windows-update-on-a-windows-7-pc/

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , , , , , , , , , | Leave a comment

Query Designer grey out in Visual Studio

This blog shows you why the Query Designer is disable or grey out in Visual Studio.

When you get the View menu to open the Query Designer then you might realize all the buttons in Query Designer is grey out like the one below.

clip_image002

Go to the Data Connection. Right click on the connection then choose “Delete” to delete the database connection.

clip_image004

Click Yes.

clip_image006

Right click on Data Connection then choose “Add Connection…

clip_image008

Click on “Change… (button)” in Add Connection dialog.

clip_image010

Choose on “.NET Framework Data Provider for OLE DB (list item)”.

clip_image012

Click on “OK (button)” in “Change Data Source”

clip_image014

Select northwind database then click OK.

clip_image016

Expand the database till you can see the tables. Choose Products table then right click on “New Query (menu item)”.

clip_image018

You can see the Query Designer is working now.

clip_image020

Resource:

https://www.youtube.com/watch?v=tMLiMnfjNaI

Posted in .Net, Community, Computers and Internet | Tagged , , , , | Leave a comment