Blog posts by Mats Decker2010-02-24T15:04:00.0000000Zhttps://world.optimizely.com/blogs/Mats-Decker/Optimizely WorldHow to restore user when database is restored.<p>A thing that always annoys me, when backup-restoring a database between database servers, is the mismatch between the sql login and database login. In some way they have the same name but some id isn't equal so they don't match. Atleast in newer versions of SQL Server you could delete one and re-map it.</p>
<p>Stumbled across this script that matches the server login and database login.</p>
<pre class="language-csharp"><code>USE [Database]
EXEC sp_change_users_login 'Update_One', 'Username', 'Username'
</code></pre>
<p>This only works when the usernames match.</p>2010-02-24T15:04:00.0000000ZBlog postDeveloper lunch: Entity Framework in .NET 4<p>For "my" developer lunch i selected an awesome session from Microsoft PDC09, called <a href="http://microsoftpdc.com/Sessions/FT10" target="_blank">Evolving ADO.NET Entity Framework in .NET 4 and Beyond</a>, where Microsoft's Shyam Pather and Chris Anderson takes us through an hour of as many new features in the new Entity Framework as possible.</p>
<p>Especially interesting is the ability to use POCO-classes (Plain Old CLR Objects) and the "Model first" concept where you remove the dependency to any base classes and begin with the logic tier. Also, with the embedding of LinqToSql into Entity Framework, the rendering of SQL-clauses and implementation of Stored Procedures in the context really takes the data access layer to a new level and remove many pitfalls seen in the past with OR mappers.</p>
<p>Adding to this with the ability to test applications with fake repositories and such i think this is the way to build applications for quite a while.</p>2010-02-13T14:10:00.0000000ZBlog postPDC09 Session - Data Programming and Modeling for the Microsoft .NET Developer<p>
</p><p>Don Box and Chris Anderson went through Entity Framework and the new stuff that has improved the developer experience. For instance you can use Entity Framework and still use IDataReader etc getting the data so you may start migrating from SqlConnection to Entity Framework without committing entirely. They also addressed the never ending story about where the framework should be modeled (database, definitions file, C# code) and the answer is ... the way you like it :). It all depends on where the model origins, for an instance if you have an existing database it will be hard to make another model in code.</p>
<p>They also showed the entity framewark talking with Share Point over OData(!) where they could access the data via and atom feed and manipulate that data directly in the share point server. I really have to look into odata!</p>
<div>On another note i really have to see more about 'M' the "data language", which they only talked about peripherally.</div>
2009-11-17T23:14:00.0000000ZBlog postA very interesting first day at PDC 09 is coming to an end.<p>We've been here in Los Angeles for a couple of days doing tourist stuff but today we were back to work. And a very interesting day at that. We rather early decided to attend the Windows 7 Developer Boot Camp session to see firsthand the new and updated features of the latest version of Windows. </p>
<p>After the initial speak of Mark Russinovich, going through general Windows 7 improvements, Arun Kishan and Landy Wang kickstarted the conference with Kernel and Memory changes.</p>
<p>Since i'm a C# developer focusing on web, there were a lot of stuff going over my head with some of the extremely technical stuff but still very interesting to know what goes around below when writing my very high level language code. But in short you should get Windows 7 for clients or upgrade to Windows Server 2008 R2 just for perfomance gain on the same computer :).</p>
<p>Arun addressed redesign of access to and handling of threads and strains. He also talked about core parking, where cores not used enters sleep mode and therefore takes a lot less power to a laptop battery's relief and in a global perspective takes a lot less power from the power grid when a billion computers are not running their two billion plus cores at full effect.</p>
<p>Landy on the other hand talked about how memory managing has changed to being more suspect about application allocation memory in an abusive way, ie when an application tries to allocate like all pages in memory the memory manager lowers the priority of the allocated memory so that smaller applications aren't effected so the only thing running slowly is the abusing program itself. By having it this way Windows 7 allocates a lot of memory to begin with but is's good memory allocation since it gives it to applications that need it. In short this means that it pays of to write good code handling memory stuff nowadays contrary to pre Windows 7 where the good applications were the ones paying for the bad applications' memory handling.</p>
<p>This is only an outtake of their whole presentations but the presentations should be online very soon and every developer should see them.</p>2009-11-17T04:54:00.0000000ZBlog postHow to log log4net<p>I had some problems with log4net not logging my site at all. It just created empty(0kB) log files, turned out to be missing write permissions to the log files directory.</p>
<p>But the interesting thing is how i found it by logging log4net by just adding two settings to my web.config file.</p>
<pre class="language-csharp"><code><appSettings>
<add key="log4net.Internal.Debug" value="true"/>
</appSettings>
<system.diagnostics>
<trace autoflush="true">
<listeners>
<add
name="textWriterTraceListener"
type="System.Diagnostics.TextWriterTraceListener"
initializeData="C:\temp\log4net.txt" />
</listeners>
</trace>
</system.diagnostics>
</code></pre>2009-10-14T12:37:00.0000000ZBlog post