Hello everybody,
some sql notes:
dbcc freeproccache; this one will clean plan of cached of sql.
Another note of how to find Sql code and plan by id from dm_exec_cached_plans
create function SqlAndPlan(@handle varbinary(max))
returns table
as
return select sql.text, cp.usecounts,cp.cac...
Hello everybody,
today I want to write few words about Moq and unit testing.
First of all you can have a question, why do I need Moq at all?
Moq is especially useful for cases if we don't have desire to code interface, then code implementation of interface, and then code fake implementation...
Hello everybody.
Today I want to give some demo.
using System;
using System.Diagnostics;
namespace StackOverflowQuest
{
class Program
{
struct StructTest
{
public string TestString { get; set; }
//public override bool Equals(object obj)...
Hello everybody,
today I want to share one trick which can save you few lines of code.
Imagine case: you created graph, and want to read something from db, and then set current property of that graph view to some value. How to do it in one line? The anser is simple, with help of Search<>
Fo...
Hello everybody,
today I want to write about reflecting hierarchy of classes in db with help of code-first.
There are three types:
Table per Hierarchy
Table per Type
Table per conreate class.
Below goes more detailed description
Table per Hierarchy (TPH): one table for the en...
Hello everybody,
today I want to share my usage if IDisposable interface in C#.
Before code presentation some explanations:
1. If created by me class uses some unmanaged resources then it means that I should also implement IDisposable interface in order to clean memory. 2. Clean objects as s...
Hello everybody.
Today I want to share notice of how to work with processing screens.
Processing screen
But of course not in very standard situation. One of my clients requested me the following: he wanted at processing screen to select some items in screen in part 1, then monitor...
Hello everybody,
today I want to write a notice about Project estimation. One of the important facetcs of making estimates is to make document, in which to describe definitions of project, which need to be estimated.
For this purpose I will create Word document with title page, table of contents...
Hello everybody,
today I want to write some notice about PCL, aka portable class library. It's possible to make library which will be possible to make library for Windows Phone 7, Xbox 360, .Net for Windows Store apps.
Hello everybody,
today I want to write few words how to work with selectors in Acumatica.
So, imagine, you have the following selector in Acumatica:
<px:PXSelector ID="NmbUsrBillPMTask" runat="server" DataField="UsrBillPMTask"/>
In order to make it work as selector, you need to do the follo...