Google+ Peter Bromberg's .NET Blog | All Things Programming

Peter Bromberg's .NET Blog All Things Programming

How to Map Stored Procedure with dynamic SQL In Entity Framework

15. November 2013 12:46 by admin in

When you do a function import to a stored proc that has dynamically - generated SQL in it, Entity Framework will report that no columns were mapped.

 

Here is an easy, non-destrctive way to make sure EF gets the column metadata to complete your function import.

 

What EF does when it attempts to map your sproc is it executes the sproc with all parameters having null values.

Of course if the resultset is generated via dynamically assembled SQL or comes from a Table Variable, EF cannot "see" the results.

 

So what we do is the following. 

 

Say your sproc returns six columns. You would return each column as a null, but casting it to it's actual datatype:

 

if ( @deptId is null and @chkExemptOnly is null  and @chkActiveOnly is null and @msYearAC is null and @msdepttypeid is null and @Firstname is null and @lastName is null ) 
begin
select
cast(null as int) as empid,
cast(null as varchar(11)) as emplID,
cast(null as int) as Active,
cast(null as varchar(25)) as lastName,
cast(null as varchar(25)) as firstName,
cast(null as varchar(25) ) as middleName
end

You can put this kind of code right at the beginning of the sproc just after the AS statement, and Entity Framework will correctly map the resultset for you. You do not need to worry about leaving the above SQL block in the sproc, since it only executes when all the input parameters are NULL.

How to Filter (Search) in a Table With jQuery

25. October 2013 11:28 by admin in Jquery

Click here for Working Sample

<!DOCTYPE html> 
<html > 
<head><meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>JQuery Table Search Demo</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
jQuery.expr[':'].contains = function(a,i,m){
return jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase())>=0;
};
$(document).ready(function(){
$('input[name="search"]').keyup(function(){
var searchterm = $(this).val();
if(searchterm.length >2) {
var match = $('tr.data-row:contains("' + searchterm + '")');
var nomatch = $('tr.data-row:not(:contains("' + searchterm + '"))');
match.addClass('selected');
nomatch.css("display", "none");
} else {
$('tr.data-row').css("display", "");
$('tr.data-row').removeClass('selected');
}
});
});
</script>
<style type="text/css">table {background-color: #FAF3DF;}table tr.data-row {background-color: #fff;}table tr.data-row td.selected-cell {color: #fff;background-color: #660000;}table tr.data-header {background-color: #F1EDE3;border-bottom: solid 2px #fff;font-weight: bold;}table tr.selected {background-color: #FFCC88;} </style></head> <body><p>Search term:<input type="text" name="search" /></p><table cellspacing="4"><tr class="data-header"><td>Contacts</td></tr><tr class="data-row"> <td>Jerald Mickey</td></tr><tr class="data-row"> <td>Minda Carlen</td></tr><tr class="data-row"> <td>Marlene Nida</td></tr><tr class="data-row"> <td>Daysi Cassano</td></tr><tr class="data-row"> <td>Bonny Medford</td></tr><tr class="data-row"> <td>Patria Sciortino</td></tr><tr class="data-row"> <td>Kathaleen Herwig</td></tr><tr class="data-row"> <td>Junior Chamberlin</td></tr><tr class="data-row"> <td>Belkis Fleishman</td></tr><tr class="data-row"> <td>Evangeline Ishee</td></tr><tr class="data-row"> <td>Reyes Newland</td></tr><tr class="data-row"> <td>Eleonore Federico</td></tr><tr class="data-row"> <td>Briana Launius</td></tr><tr class="data-row"> <td>Eula Bernard</td></tr><tr class="data-row"> <td>Albert Palm</td></tr><tr class="data-row"> <td>Zofia Schlachter</td></tr><tr class="data-row"> <td>Donnette Nichols</td></tr><tr class="data-row"> <td>Herta Hile</td></tr><tr class="data-row"> <td>Lurlene Pfeffer</td></tr><tr class="data-row"> <td>Teresita Wasson</td></tr><tr class="data-row"> <td>Milagros Copes</td></tr><tr class="data-row"> <td>Ai Stimac</td></tr><tr class="data-row"> <td>Brigida Rake</td></tr><tr class="data-row"> <td>Alida Paxton</td></tr><tr class="data-row"> <td>Juliann Mattingly</td></tr><tr class="data-row"> <td>Phil Cervantes</td></tr><tr class="data-row"> <td>Lauryn Salgado</td></tr><tr class="data-row"> <td>Glady Lavergne</td></tr><tr class="data-row"> <td>Shawna Koerber</td></tr><tr class="data-row"> <td>Alana Halloway</td></tr></table> </body> </html>

How to Keep Your Hard Drive Clean and Mean

14. October 2013 13:11 by admin in
A Couple of recommendatations: 1) Temp File Cleaner by OldTimer TFC (Temp File Cleaner) will clear out all temp folders for all user accounts (temp, IE temp, java, FF, Opera, Chrome, Safari), including Administrator, All Users, LocalService, NetworkService, and any other accounts in the user folder. It also cleans out the %systemroot%\temp folder and checks for .tmp files in the %systemdrive% root folder, %systemroot%, and the system32 folder (both 32bit and 64bit on 64bit OSs). It shows the amount removed for each location found (in bytes) and the total removed (in MB). Before running it will stop Explorer and all other running apps. When finished, if a reboot is required the user must reboot to finish clearing any in-use temp files. Get it here: http://goo.gl/cz0WfCCleaner (Crap Cleaner): CCleaner is the number-one tool for cleaning your Windows PC. It protects your privacy online and makes your computer faster and more secure. Easy to use and a small, fast download. Download here: http://goo.gl/P7N5