How to execute one or many SQL files and handle all outputs in .NET
Have considered about this requirement for a while and after some studies I found few options. Here are some:
Software development processes / techniques / news
Have considered about this requirement for a while and after some studies I found few options. Here are some:
My application requires a unique id on some entities but it shouldn’t be the GUID (it’s good but it’s little long).
Today I integrate my application with Twitter and user now can sign-in by their Twitter account.
It’s not so hard with support of the libraries Microsoft.Owin.Security.Twitter
or Owin.Security.Providers
.
Beside, there are some issues soonly happens.
When upgrating an application to a newer version, it often requires to migrate its data (including delete/update some entities, add some new entities / configurations). At development phase, we often need to build some sample data for dev / test environments and reference data for production environment. DataUp comes to simplify this work, it was inspired by EF migrations & DbUp.
I got remote access issue of SQL Server 2K8 R2 on Windows Server 2K8 R2 which has firewall turned on. The fix took awhile so this post will note all steps that have been performed.
I deploy a sample application called SoftNews on AppHarbor. It works pretty well without any purchase as I still use free services (with small free RavenDB / Redis instances)
This post will explain how to automatically deploy database for an application in Octopus with EntityFramework.
It is possible to deploy new version of application to a specific environment on its new release creation. This straightforward method makes testing / deployment easier as the environment usually is for dev / dev integration.
This post explains all steps needed to install, work with Octopus Deploy that I have passes through. After some short of investigations, it’s really nice and should be in hands of .NET developers / production engineers.
The testing purpose of webapioauth.apphb.com requires to use a FQDN rather than using localhost as usual. So it requires to do some modification on IISExpress settings. Below steps are easily to make work.
I got an issue when deploying an application to AppHarbor cloud Platform regarding empty folder (!). It is a serious one because the application crash after deployment even with a experimental project.
EntityFramework contains ObjectQuery type which supports to perform advanced and dynamic query for entity with SQL-like syntax.
By default, WCF uses Windows to validate username / password. We can customize this process as well. This post will describe how to to authenticate a client, then authorize its behavior.
Asynchronous programming will help us improve performance and responsiveness of the app.
The new architecture containing async
and await
keywords does almost difficult job and let developers
write code similarly to synchronous code.
This post is about Messaging Patterns provided by WCF that I have learnt. It includes one-way, request/reply, streaming, and duplex communication.
Using XPath is an effecient way to query, filter in XML document. I will explain some practices using XPath.
XML is widely used in many applications and if familiar with it will be so helpful in coding activity. In this post we will go through a common scenario which produces string repsentation of a XmlDocument then you will see different methods with different behaviors they produce.
This post will drive you to create WCF Data Service and how to use it in your client application. A Windows Console application will be created to comsume the service by using its proxy. For Web application, it can be called by activating URL with HTTP method.
In this post I will share my little POC on Azure Cloud Storage including Blob / Queue. There are other ones like DocumentDB / Azure Tables / SQL Database, I had worked with but another post will cover these parts later. All code samples can be found in this repository on github
There are different data access technologies including ADO.NET, Entity Framework, WCF Data Services… with different benifits. Below is some key points of those technologies