Finding gaps in a sequence of identifier values of sql table.

Today I would like to present a couple of solutions for problem of finding gap in a sequence. This issue will be considered in context of finding missing – gap identifiers in the database table. All examples of code are T-SQL scripts and statements and were tested on SQL Server 2008 Express 1. Integer typed identifiers Lets assume we have an sql table with following schema Fiel…

By Mirek on (tags: gaps in sequence, id gap, table id finding, categories: code)

MVC Greedy route mapping and custom route handler

I’m learning to love MVC mostly for it’s flexibility. In a recent situation, I wanted to have a generic controller that will perform CRUD (Create Read Update Delete) operations on an entity. By default, this is not handled, but with a little custom code, it turned out to be quite easy.

By eidias on (tags: mvc, categories: code)

Simple WCF. RESTful and SOAP endpoint at one contract.

REST (Representational state transfer) web service is a service over HTTP with specific architecture. The REST is then an architectural style, which defines the rules of accessing resources exposed in the web. In principle the restful service exposes some sort of resource, for instance collection of entities, which can be easily accessed and changed from external client. To be …

By Mirek on (tags: REST, SOAP, WCF, web service, categories: code)

Simple WCF. The simplest configuration.

The power of WCF is that it can be used to any kind of communication. All known old transmission protocols are covered by WCF and can be totally replaced by it.

 

By Mirek on (tags: WCF, categories: code, web)

Breaking strong name in .net library assemblies.

Recently I was digging in Strong naming and signing in .net. I have found an interesting article on code project Building Security Awareness in .NET Assemblies which describe how the strong name can be easily removed and beaked from an executing assembly. I would like to present the approach that can be used with library assemblies in .net. What is a strong name (also called st…

By Mirek on (tags: Assembly signing, .net, Strong name, categories: code, security)

WCF Data Services performance

The main benefit of using WCF Data Services (formerly ADO.NET Data Services, codename "Astoria) is that this is interoperable, which means it can be accessed from clients created in different technologies. Moreover standard WCF services offers the only exposed set of methods. Data Services, as implementation of OData protocol, offers the Resource to be queried and altered …

By Mirek on (tags: Data Services, OData, WCF, categories: architecture, code)

Reading manifest from assembly

Information like product name, file version, copyright, etc are stored in the assembly manifest. In this post I would like to present how these informations can be read from an assembly and showed in the UI.

By Mirek on (tags: assembly information, manifest, categories: code)

EF Code First and SqlServer Ce 4.0 – the simplest example ever.

Recently I needed to write a simple database application. I chose the Entity Framework Code First (Code Only) as a Object Relational Mapper (ORM) because its simplicity and quick development process. If you did not yet heard about EF Code First then this is a good place to start. Entity framework is a very powerful technology. It totally makes the whole dirty work which in the …

By Mirek on (tags: Code First, Entity Framework, SqlServer Ce 4.0, categories: code)