NHibernate and Execution Plans(objectreference.net)

submitted by Vort3X(1335) 2 years, 7 months ago

Lately we have been investigating ORM’s (Object Relational Mapping) frameworks for use on a large enterprise level website which we been given the rare opportunity to rebuild from the ground up in Microsoft MVC. We decided to go ahead with NHibernate until stumbled across a major issue causing queries run by NHibernate not re-using SQL Server execution plans. read more...

add a comment |category: Architecture |Views: 275

tags: Architecture another

Learning new Programmming Languages and Technologies(objectreference.net)

submitted by Vort3X(1335) 2 years, 11 months ago

Recently, I’ve read article after article about how part of being a good software developer is about being open to new technologies, and to “learn new things” – and I’d be foolish not to agree. However... read more...

add a comment |category: Community |Views: 460

tags: learning Community another

Construct a comma delimited list from table column with SQL(objectreference.net)

submitted by magz(80) 3 years, 4 months ago

How many times have you had to create a comma delimited list from a table column? Do you ever remember how to do it? I don’t. Here is a little snippet I find useful read more...

add a comment |category: Database |Views: 321

tags: Database another

Implementing a red black tree in C#(jaltiere.com)

submitted by jaltiere(885) 3 years, 5 months ago

This article talks about how to implement a red-black tree in C#. The implementation is generic, and it also implements IEnumerable<T>. read more...

add a comment |category: C# |Views: 1002

tags: C# another

RegEx Multiple Matches with Lookahead Assertion(objectreference.net)

submitted by Vort3X(1335) 3 years, 6 months ago

This is a quick article where I would like to show how to use regular expression to get all matches of a particular pattern from the string. read more...

add a comment |category: C# |Views: 236

tags: C# another

SQL Find last week date range(objectreference.net)

submitted by Vort3X(1335) 3 years, 6 months ago

The other day we needed to write a report on online sales for the last week. SQL doesn’t offer developers many predefined functions to work with date ranges unlike the C# programming language. Here is a little example how to query SQL for some data between the dates for the last week. read more...

add a comment |category: Database |Views: 445

tags: SQL Database another

BlogEngine Flaws(objectreference.net)

submitted by Vort3X(1335) 3 years, 9 months ago

Recently I’ve been having problems as the site has gotten more popular I’ve had comments and even posts disappearing randomly, sometimes re-appearing you might have experienced this yourself either on my site or in your own so after divulging into the code to see what was happening found something I thought was shocking. When you add a comment, or Rating, Approving and Remove Comments this is what BlogEngine DbBlogProvider actually does... read more...

add a comment |category: Open Source |Views: 245

tags: OpenSource another

Web developers. You suck.(objectreference.net)

submitted by Vort3X(1335) 3 years, 10 months ago

Well, JavaScript developers, specifically. In order to aid in development of my own websites, I enabled JavaScript debugging in Internet Explorer a few weeks back. To my horror, I have quickly experienced what seems to be complete disregard for serving syntactically correct JavaScript on the open internet. No, I’m not just talking about a few niche websites, run by amateur programmers. I am talking about industry-leading nerd-friendly powerhouse websites that should know better. read more...

4 comments |category: AJAX |Views: 654

tags: JavaScript AJAX another

Get Checked Repeater Items Extension Method(objectreference.net)

submitted by Vort3X(1335) 3 years, 11 months ago

Imagine you have a list of some items and checkboxes next to each item providing the ability for a user to make multiple choices and submit a result in one go. Weather you are implementing a news groups subscription, user survey or online products catalogue - the code behind is the same: we bind some object list to a data control like Repeater, add a checkbox to every item, set checkbox value to item ID. read more...

add a comment |category: C# |Views: 181

tags: C# another

enum to friendly string extension method(objectreference.net)

submitted by Vort3X(1335) 3 years, 11 months ago

We use enums quite extensively in our application as they are a great for representing integral values in a strongly typed way using symbolic names. The enum names are not very friendly to the user and I recently read a some good articles which tried to solve this problem. However, I think i've found a better solution to this problem using extension methods. read more...

add a comment |category: C# |Views: 382

tags: C# another

SCOPE_IDENTITY() return the id from the database on insert(objectreference.net)

submitted by Vort3X(1335) 4 years ago

As a .NET programmer most of my time is spent coding in C# and I try to avoid writing SQL where possible. Recently I had to write an insert stored procedure and needed to return the ID of the row I was inserting. While writing my usual bad SQL I came across a fascinating function I’ve never used before, SCOPE_IDENTITY(). read more...

7 comments |category: Database |Views: 324

tags: Database another

the LinqToSQL is a lie(objectreference.net)

submitted by Vort3X(1335) 4 years ago

LinqToSql is amazing! I've been working with it for the past week and loving every moment. However i've noticed somethig weird, it lies to me about the SQL it's generating. Here is my example... read more...

4 comments |category: Linq |Views: 33

tags: LinqToSql LINQ another

A C# Operator I would like to see.(objectreference.net)

submitted by Vort3X(1335) 4 years ago

You could argue there are too many operators in C# as it is; however, I feel having an acute knowledge of the available operators is like knowing CTRL + B will bold the selected text in most word processing software. To put it simply, it hurts no-one, whilst providing shortcuts to advanced users... read more...

add a comment |category: C# |Views: 14

tags: C# another

Implementing Generic Caching(objectreference.net)

submitted by Vort3X(1335) 4 years ago

I develop for a large, high-availability website, with hundreds of thousands of daily users. As such, we need to cache a lot of data in our web-server memory (which is cheap) to save numerous hits to our main database cluster (which is very expensive). I would imagine the desire to improve performance by saving on database hits is common across many web applications – and caching frequently used data is often seen as one of the best ways to solve this problem. read more...

6 comments |category: C# |Views: 232

tags: C# another

Select Text or Value From DropDownList Extension Method(objectreference.net)

submitted by Vort3X(1335) 4 years, 1 month ago

I keep forgetting how to do it and end up spending ages searching for it, so here is a very usefull extension method that allows you to select an item from a DropDownList using the text or value of the item without needing to know the index of the item. read more...

add a comment |category: C# |Views: 21

tags: C# another

RestLess - A Simple REST Framework Part 2 : ndepth.net(ndepth.net)

submitted by javery(5523) 4 years, 1 month ago

An updated to Jayme's RestLess framework with some general improvements (better URLs) and some new properties. read more...

add a comment |category: Web Services |Views: 99

tags: WebServices REST another