Data Access (formerly Open Access ORM), the Telerik  free .NET object-relational mapping tool

 

 

from http://www.telerik.com/data-access

is part of Telerik DevCraft—the ultimate product bundle for professional developers targeting Microsoft platforms.

Gain access to the complete stack of products to help you build your next web, mobile or desktop app:

  • UI suites for all .NET platforms and HTML5 (ASP.NET AJAX, MVC, HTML5, Silverlight, WPF, WinForms and Windows 8)
  • Reporting and data layer generation tools
  • Developer productivity tools for better and cleaner code
    • Supported Databases

      • Microsoft SQL Azure
      • Microsoft SQL Server 2000, 2005, 2008, 2012
      • Microsoft SQL Server 2005, 2008, 2012 Express, LocalDB
      • Microsoft SQL Server Compact 3.5, 4.x
      • Oracle Server 10.x, 11.x
      • Oracle Database 10g, 11g Express Edition
      • MySQL 5.x
      • Maria DB 10.0 Alpha
      • SQLite
      • PostgreSQL 9.1
      • Firebird 2.x
      • Advantage Database Server 9.1, 10.1
      • Sybase SQL Anywhere 11.x, 12.x
      • VistaDB

    • LINQ Support

      Data Access offers extensive LINQ support against all supported databases, which has been validated with the Microsoft 101 LINQ to SQL Samples (available in the Data Access Samples Kit). The major advantage of LINQ is the compile-time check of your queries-meaning no surprises at run time.


    • Utilizing Specific Database Features

      Telerik Data Access can be used with a wide variety of relational backends. It offers specific features such as support for SQLGeometry and SQLGeography types in MS SQL Server, RefCursors and Auto-increment Sequences in Oracle. It also offers various types of Stored Procedures and Functions for each database, Data streaming to blob storage columns and more.

      Utilizing Specific Database Features

 


  • Utilizing Specific Database Features

    Telerik Data Access can be used with a wide variety of relational backends. It offers specific features such as support for SQLGeometry and SQLGeography types in MS SQL Server, RefCursors and Auto-increment Sequences in Oracle. It also offers various types of Stored Procedures and Functions for each database, Data streaming to blob storage columns and more.

    • Database-first mapping is the process of creating a set of objects and .NET classes to be used in your application from an already existing database. This approach is also known as Schema-First and Reverse Mapping. Data Access recognizes the data model, the data types and any additional information like keys and stored procedures, and then generates the object model and related C# or VB.NET code. The process is transparent and you have complete control over the created mapping by using the Create Model Wizard.

      reverse-mapping

    • forward-mapping

      Model-First (Forward) Mapping

      Model-First Mapping (also known as Forward mapping) takes your existing object model and creates an optimized database schema. In Telerik Data Access, this process is handled by the Update Database from Model wizard. It can generate your database and maintain its schema for you so that you will not have to do anything during the design phase.


    • Round-Trip (Mixed Mode) Mapping

      The unique capability called Round-trip Mapping means you don’t have to choose in advance whether to forward- or reverse-map your project. With the help of Telerik Data Access Visual Designer in Visual Studio, you employ both approaches.


    • Code Only Mapping (Fluent API)

      Code Only Mapping (Fluent API)

      If you view code as your model, preferring to write code instead of using visual assistance tools, Telerik Data Access provides Fluent Mapping API that assists you in setting-up your classes for use with Data Access. There is no need to touch a designer or work with the XML mappings.The completely automated, initial Fluent Mapping code generation is done by Data Access. The Data Access Fluent API covers 100 percent of the the functionality of the mapper, and is efficiently used by Telerik Sitefinity CMS.  If required, your model can be visually adjusted in the Visual Mapping Designer.


    • Mapping Stored Procedures and Functions

      Data Access allows you to create new or reuse existing Stored Procedures and follow the widely adopted pattern of DB logic encapsulation inside the database. Under higher security requirements, the stored procedures can be used for all insert, read, update and delete operations to inject additional checks in the database server. A Stored Procedures Editor simplifies the set-up and use of stored procedures.

      Mapping-Stored-Procedures-and-Functions

    • Mapping-Tables-and-Views

      Mapping Tables and Views

      Telerik Data Access forward and reverse mapping enables you to map database views and tables to classes. The data exposed by the tables and views can be modified and then stored back to the database.


    • Model Creation

      The Data Access Model is created in Visual Studio with the aid of numerous tools and wizards, which simplify the process to point-and-click table to object mapping. The model describes the application-specific object or “conceptual” model against which you can program. It raises the abstraction level above logical database schemas, which also allows you to reuse it in different applications and for different databases.

      Model-Creation

    • Native .NET API, ZERO Reflection, Application Portability

      Data Access uses standard .NET conventions and idioms (inheritance, polymorphism, composition, .NET/generic collections, etc.).  It does not use .NET reflection. The code is free of data access code “plumbing” and is enhanced transparently after compilation. The code generated by Data Access closely follows all established .NET and object-oriented programming standards.

      All classes in Telerik Data Access are persistent ignorant and work independently from the source code and database. This means true portability for your .NET applications, where you can switch the database and reuse the same code and even data model.


    • Change Tracking and CRUD Operations

      You only need to modify the state of an object when updating data – Data Access takes care of the rest. Because the programming model does not change, you do not need to know any of the SQL performed on the backend. Telerik Data Access converts the commands issued by the domain model at runtime (usually via LINQ or low-level API), into backend database retrieval and SQL statements. This frees you from writing the time-consuming CRUD operations. Data Access helps you with the following CRUD operations:

      • Create– instantiate a .NET object and add it to the Data Access context
      • Read– use LINQ to retrieve objects from the database
      • Update– once you have a reference to a persistent object, you simply make changes to the object state
      • Delete– pass the object to be deleted to the Data Access context
      Change Tracking and CRUD Operations

    • Model-Operations-Dialog-for-Instant-Mapping-Modification

      Model Operations Dialog for Instant Mapping Modification

      Data Access provides the Model Operations that enable you to update your model in a few clicks. This is done through a simple dialog, so you can:

      • Update many (or all) classes and properties using a configurable batch operation, such as changing class namespaces, changing property types and more
      • Speed-up the process of making changes in class and property names by presenting them in a data grid
      • Always have a good reference for the current state of your model using a grid-based overview

    • Testability

      All classes enhanced by Telerik Data Access are still normal CLR objects, and as such, can be easily tested by state of the art unit tests. SQL code can be traced by writing it to the console, in a text file or to the .NET tracing framework. Performance counters show you the state of your running application, website or application server.

      Testability

 

From http://www.pluralsight.com

Now on Pluralsight:

The ASP.NET MVC 5 Fundamentals training course spends most of its time on new features for version 5 of the framework, including:

ASP.NET MVC 5 Fundamentals covers all the new features of ASP.NET MVC 5, as well as the new features for web developers in Visual Studio 2013, including WebApi 2, OWIN, Katana, SignalR, and the Entity Framework version 6
from http://odetocode.com/blogs/scott/archive/2012/11/20/two-asp-net-mvc-4-courses.aspx

The Building Applications with ASP.NET MVC 4 training course is a start to finish introduction to programming with ASP.NET MVC 4. Some of the demos in the 7+ hours of content include:

– Using controllers, action results, action filters and routing

– Razor views, partial views, and layout views

– Models, view models, data annotations, and validation

– Custom validation attributes and self-validating models

– Entity Framework 5 code-first programming

– Entity Framework migrations and seeding

– Security topics including mass assignment and cross site request forgeries

– Using JavaScript and jQuery to add paging, autocompletion, async form posts, and async searches

– Taking control of Simple Membership

– Using OAuth and OpenID

– Caching, localization, and diagnostics

– Error logging with ELMAH

– Unit testing with Visual Studio 2012

– Deploying to IIS

– Deploying to a Microsoft Windows Azure web site

Enjoy!

How to Deploy .Net Core Web Application to Ubuntu Linux

ASP.NET Web API Attribute Based Routing

Route attributes bring the URL definition closer to the code that runs for that particular URL, making it easier to understand which URL must be called for a particular block of code and simplifying many common routing scenarios.

For example, let’s say you want to define a Web API that has the standard set of HTTP actions (GET, POST, PUT, DELETE, and so on) but you also want to have an additional custom action, such as Approve. Instead of adding another route to the global route table for the Approve action, you can instead just attribute the action directly:

public class OrdersController : ApiController

{

public IEnumerable<Order> GetOrders() {…}

public Order GetOrder(int id) {…}

public Order Post(Order order) {…}

[HttpPost("orders/{id}/approve")]

public Order Approve(int id) {…}

}

An extended route template syntax makes it simple to specify default values and constraints for route values. For example, you can now easily create two actions that are called based on parameter type. In the following People controller, the id parameter of the GetByID action takes only int values. The GetByName action method contains a default name of “Nick”.

public class PeopleController : ApiController

{

[HttpGet("{name=Nick}")]

public string GetByName(string name) {…}

 

[HttpGet("{id:int}")]

public string GetById(int id) {…}

}

You can also define common route prefixes for your web APIs. For example, you can use route prefixes to set up a resource hierarchy:

[RoutePrefix("movies")]

[RoutePrefix("actors/{actorId}/movies")]

[RoutePrefix("directors/{directorId}/movies")]

public class MoviesController : ApiController

{

public IEnumerable<Movie> GetMovies() {…}

public IEnumerable<Movie> GetMoviesByActor(int actorId) {…}

public IEnumerable<Movie> GetMoviesByDirector(int directorId) {…}

}

Or, you can use route prefixes to handle multiple versions of your web API:

[RoutePrefix("api/v1/customers")]

public class CustomersV1Controller : ApiController {…}

 

[RoutePrefix("api/v2/customers")]

public class CustomersV2Controller : ApiController {…}

Similar to the new CORS support in ASP.NET Web API, the new support for attribute-based routing is largely a contribution from the community.

How to Add A PHP Code to your WordPress Posts, Pages and Widgets

A very good youtube video that shows how to add php code into wordpress page.

The steps are:

1. Install ‘PHP Code Widget’ plugin.

2. Install ‘Insert PHP’ plugin.

3. Start writing php code inside wordpress pages and posts.

Here is a link to the original youtube video:
https://www.youtube.com/watch?v=-CYe0q1K45I

 

Passing parameters to Web Service

1. For example you created a Web service an placed it at your IIS. You will access it as follows:

Web services address:
http://localhost/WebService.asmx

2. At this stage the Web service will displays a list of all of it’s functions.

3. Calling web services by GET method with functions with parameters:

http://localhost:49614/WebService.asmx/add?num1=10&num2=12

Add - Function Name
Num1 - Parameter1 
Num2 - Parameter2

4. Calling web services by POST method:

<form method=POST action='http://localhost:49614/WebService.asmx/add'>
<input type="text" size="5" name='num1'"></td> -
<input type="text" size="5" name='num2'"></td> =
<input type=submit value="add"> </td>
</form>

 

(Taken from Wikipedia)

Fuzzy logic is a form of many-valued logic which deals with reasoning that is approximate rather than fixed and exact. Compared to traditional binary sets (where variables may take on true or false values), fuzzy logic variables may have a truth value that ranges in degree between 0 and 1. Fuzzy logic has been extended to handle the concept of partial truth, where the truth value may range between completely true and completely false. Furthermore, when linguistic variables are used, these degrees may be managed by specific functions.

The term “fuzzy logic” was introduced with the 1965 proposal of fuzzy set theory by Lotfi A. Zadeh. Fuzzy logic has been applied to many fields, from control theory to artificial intelligence. Fuzzy logic had, however, been studied since the 1920s, as infinite-valued logic—notably by Łukasiewicz and Tarski.

http://en.wikipedia.org/wiki/Fuzzy_logic

ReactOS® is a free open source operating system based on the best design principles found in the Windows NT® architecture (Windows versions such as Windows XP, Windows 7, Windows Server 2012 are built on Windows NT architecture). Written completely from scratch, ReactOS is not a Linux based system, and shares none of the UNIX architecture.

The main goal of the ReactOS® project is to provide an operating system which is binary compatible with Windows. This will allow your Windows® applications and drivers to run as they would on your Windows system. Additionally, the look and feel of the Windows operating system is used, such that people accustomed to the familiar user interface of Windows® would find using ReactOS straightforward. The ultimate goal of ReactOS® is to allow you to use it as alternative to Windows® without the need to change software you are used to.

https://www.reactos.org/

Freeing Disk Space on C: Windows Server 2008

  • Deleting any files/folders from C:windowstemp and C:Users%UserName%AppDataLocalTemp
  • Delete all EventViewer logs
    • Save to another Disk if you want to keep them
  • Remove any unused programs, e.g. Firefox
  • Remove anything in C:inetpublogs
  • Remove any file/folders C:WindowsSystem32LogFiles
  • Remove any file/folders from C:Users%UserName%Downloads
  • Remove any file/folders able to be removed from C:Users%UserName%Desktop
  • Remove any file/folders able to be removed from C:Users%UserName%My Documents
  • Stop Windows Update service and remove all files/folders from C:WindowsSoftwareDistribution
  • Deleting an Event Logs
  • Run COMPCLN.exe
  • Move the Virtual Memory file to another disk

However this wasn’t enough & I found the most space was cleared by using the Disk Cleanup tool “cleanmgr.exe” but of course this isn’t installed by default on Windows Server 2008.
In order to get the Disk Cleanup you need to go to Server Manager > Add Features > and turn on “Desktop Experience”

desktop_experience

After running the Disk Cleanup I found this gem “Hibernation File Cleaner” was using almost 7.45 GB, I’m pretty

sure I don’t need Hibernate functionality on an always on Web Server.

hibernation_file_cleaner

 

Derived from:
http://blog.willbeattie.net/2013/06/freeing-disk-space-on-c-windows-server.html

WinDirStat is a disk usage statistics viewer and cleanup tool for various versions of Microsoft Windows.

Note: if you are looking for an alternative for Linux, you are looking for KDirStat (apt-get install kdirstat on Debian-derivatives) and for MacOS X it would be Disk Inventory X or GrandPerspective.

Please visit the WinDirStat blog for more up-to-date information about the program.

On start up, it reads the whole directory tree once and then presents it in three useful views:

  • The directory list, which resembles the tree view of the Windows Explorer but is sorted by file/subtree size,
  • The treemap, which shows the whole contents of the directory tree straight away,
  • The extension list, which serves as a legend and shows statistics about the file types.

Screenshot

The treemap represents each file as a colored rectangle, the area of which is proportional to the file’s size. The rectangles are arranged in such a way, that directories again make up rectangles, which contain all their files and subdirectories. So their area is proportional to the size of the subtrees. The color of a rectangle indicates the type of the file, as shown in the extension list. The cushion shading additionally brings out the directory structure.

Derived from here:
https://windirstat.info/index.html
 
Download from here:
https://windirstat.info/download.html




Keyword to find this post

Win Disk Stat, WinDiskStat, Hard Disk space, hdd space, Disk free space, Disk Stat, Disk statistics, hdd free disk space, free space

Windows Installer Folder – Is it safe to delete

Over time this folder can grow to over a Gigabyte or more in size. Some laptops that may only be a few years old could have relatively small hard drives and free drive space is at a premium. Here is a relatively simple solution to the problem.

Background Information:
The C:WindowsInstaller folder is where some but not all applications uninstall files and folders are stored. In my previous article on using a utility named “msizap” I showed how you can reduce the size of this folder by deleting orphaned files. However on a well maintained computer you may not have all that many orphaned files and msizap can only recover a small amount of drive space. So try running msizap first and if there is still a large amount of space being consumed then it’s time for the next suggestion.

Backing up or Relocating the Installer files and folders:
For laptop or desktop users burn the contents of the Installer folder to a DVD (even if you have more than 12GB of files and folders it’s only 3 DVD(s). You can use an external USB drive but if the drive should fail then all is lost. After the files have be safely burned to DVD media then delete everything under the C:WindowsInstaller folder.

Warning:
Once you have deleted these files you will no longer be able to uninstall some of your applications. As a test I tried uninstalling at random applications listed in the Control Panel’s Add or Remove program list. Two software applications uninstalled just fine, Turbo Tax did start the uninstall process but failed to complete, MS Office 2007 Visio Viewer gave a warning that it could not uninstall and asked to insert the CD Media. MS Office 2003 gave a warning about not being able to find the “Msocache” folder. For more information on the Msocache folder see: “Local Install Source (Msocache)” http://support.microsoft.com/default.aspx?kbid=825933#appliesto

I After I restored the files/folders back into the C:WindowsInstaller folder I tried to uninstall Turbo Tax again but found that clicking on the “Change/Remove” button did nothing. Retrying to uninstall the Visio Viewer work fine and the product was uninstalled. MS Office also uninstalled properly after I had copied all the installer files
and folders back.

Conclusion:
Backing up the files and folders to a DVD and then deleting the contents of the
C:WindowsInstaller folder can free up valuable disk space. Just remember to restore
these files and folders before you try to uninstall any software. After you have uninstalled
the unwanted software application then (since you have a DVD backup) delete the
files/folders once again until the next time they are needed.

 

Driveled from:
http://www.pagestart.com/windowsinstallerfolder.html

PerformancePoint 2013 Dashboard Designer fails to start

Issue:

After the SharePoint 2013 October 2013 cumulative update (CU) the PerformancePoint 2013 dashboard designer fails to start and gives error “Application cannot be started.  Contact the application vendor.”

 

Cause:

The dashboard designer files were not signed correctly during the CU build process.

 

Workaround:

**This issue has been resolved in SharePoint 2013 Service Pack 1

Backup these files on all your SharePoint servers:

C:Program FilesCommon FilesMicrosoft SharedWeb ServerExtensions15TEMPLATELAYOUTSppsma1033Designer.Application

C:Program FilesCommon FilesMicrosoft SharedWeb ServerExtensions15TEMPLATELAYOUTSppsma1033DesignerInstallDesigner.exe.manifest

C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions15TEMPLATELAYOUTSppsma1033DesignerInstallMicrosoft.SharePoint.Client.Runtime.dll

C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions15TEMPLATELAYOUTSppsma1033DesignerInstallMicrosoft.PerformancePoint.Scorecards.Client.dll

C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions15TEMPLATELAYOUTSppsma1033DesignerInstallMicrosoft.PerformancePoint.Scorecards.DesignerPlugins.dll

C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions15TEMPLATELAYOUTSppsma1033DesignerInstallMicrosoft.SharePoint.Client.dll

Replace the files above with the files contained in the PPS.zip attached to this blog post.

 

Final Notes:

This issue has been resolved in SharePoint 2013 Service Pack 1

PPS.zip

Acronims:

BI:
OLTP - Online Transaction processing
OLAP - Online Analytical processing
Hardware:
PCMCIA - People can't memorize computer industry Acronims

This plugin provides users with a to-do list feature.

You can configure the plugin to have private to-do lists for each user, to have all users share a to-do list, or to have a master list with individual completion of items. The shared to-do list has a variety of settings available. You can assign to-do items to a specific user (includes a setting to email a new to-do item to the assigned user) and optionally have those items only viewable by that user. You can also assign different permission levels using capabilities. There are also settings to show deadline and progress fields. Category support is included as well as front-end administration.

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool inMicrosoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors – Multidimensional and Tabular (from wikipedia).

Learn SSAS: PDF, Videos and Demo files:

01. Download SSAS Tutorials PDF file from Microsoft
02. Adventure Works for SQL Server 2012 from CodePlex
03. SSAS 11 Videos of PCTeach.me:
04http://pcteach.me/Series/microsoft-ssas/
05. 6 Lessons of SSAS MDX
06. 7 Videos of SSAS MDX

SSAS Videos at PCTeach.me:

01. Analysis Services - 01 Prerequisite Guide
02. Analysis Services - 02 Data Source Creation
03. Analysis Services - 03 Data Source Views
04. Analysis Services - 04 Cube Creation
05. Analysis Services - 05 Dimension Fundamentals
06. Analysis Services - 06 Dimension Hierarchies
07. Analysis Services - 07 Dimension Attribute Relationships
08. Analysis Services - 08 Dimension Storage
09. Analysis Services - 09 Dimension Discretization
10. Analysis Services - 10 Parent/Child Dimension Hierachies
11. Analysis Services - 11 Star and Snowflake Schemas

 

ALTER PROCEDURE [dbo].[Mulsp] @Size INT
AS
BEGIN
DECLARE @X INT=2
DECLARE @Y INT=1

BEGIN try
DROP TABLE [dbo].[multable]
END try

BEGIN catch
END catch

CREATE TABLE [dbo].[multable]
(
c1 INT
)

–create the rows 
DECLARE @CN NVARCHAR(max)=
DECLARE @TSql NVARCHAR(max)

WHILE @x <= @Size
BEGIN
SELECT @cn = ‘c’ + Cast(@x AS NVARCHAR)

PRINT @cn

SET @TSql=‘alter table MulTable add ‘ + @cn + ‘ int’

PRINT @Tsql

EXEC sys.Sp_sqlexec
@Tsql

SET @x=@x + 1
END

–at this point build each line query 
SET @X=1

DECLARE @EachLineQuery NVARCHAR(max)

WHILE @Y <= @Size
BEGIN
SET @EachLineQuery=‘insert into MulTable values (‘

WHILE @x < @Size
BEGIN
SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘,’
SET @x=@x + 1
END

SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘)’

EXEC sys.Sp_sqlexec
@EachLineQuery

PRINT @EachLineQuery

SET @EachLineQuery=
SET @y=@y + 1
SET @x=1
END

SELECT *
FROM   multable
END

What Arena Does

Business Process Modeling

Few business decisions are straightforward. Changes in one area of your business impact other areas—often in ways not anticipated. Business process modeling software is an effective way to evaluate the full implications of business decisions before they are put into practice.

 

How It Works

Discrete Event Simulation

Discrete event simulation describes a process with a set of unique, specific events in time. These flexible, activity-based models can be effectively used to simulate almost any process. For 30 years, Arena has been the world’s leading discrete event simulation software.


 https://www.arenasimulation.com/