Salvo Davide Rapisarda

Linq2Sql: How to loop over context tables ?

Blackat.NET — Fri, 30 Nov 2012 14:20:00 GMT

I use linq2sql in my project not using direct table mapping but using sql views as link. Sometimes (all depend by other collegues) there is a reason for modify/add a table field in db structure. Ok, I think it's normally but if the table is included in a view then my context goes "BOOM!!!".

I have a context with 33 entities and every time i don't want to check one by one.

Problem: How to check if every entity doesn't have mapping problem?

Solution: Loop over every entities and call Any() method for each entity.

Description: If, for each entity in context, call Any() method then I can found where there is a mapping problem,

Code:

Private Function DoTest()
        Dim properties() As PropertyInfo

        properties = GetType(MyDataClassesDataContext).GetProperties()
        For Each p In properties
            If p.PropertyType.IsGenericType Then
                Dim attribs() As Object
                attribs = p.PropertyType.GetGenericArguments()(0).GetCustomAttributes(GetType(TableAttribute), False)
                If (attribs.Length > 0) Then

                    If p.Name IsNot Nothing Then
                        resultList.Add(getItem( db.GetTable(DirectCast(db.[GetType]().GetProperty(p.Name).GetValue(db, Nothing), ITable).ElementType)))
                    End If

                End If
            End If
        Next

End Function

Private Function getItem(ByVal o As Object) As ResultItem
        Dim result As ResultItem
        Dim errmsg As String
        errmsg = ""
        If TryInvokeEntity(o, errmsg) Then
            result = New ResultItem With {.ViewName = o.ToString(), .Status = "OK", .ErrorMessage = ""}
        Else
            result = New ResultItem With {.ViewName = o.ToString(), .Status = "KO", .ErrorMessage = errmsg}
        End If
        
        Return result
End Function
 
 
Private Function TryInvokeEntity(ByVal source As IQueryable, ByRef errmsg As String) As Boolean
        Dim first As MethodCallExpression
        
        first = Expression.Call(GetType(Enumerable), _
                               "Any", _
                               New Type() {source.ElementType}, _
                               New Expression() {source.Expression})
        Try
            source.Provider.Execute(first)
            Return True
        Catch ex As Exception
            errmsg = ex.Message
            Return False
        End Try
        
        
End Function

70-480...got it!

Blackat.NET — Thu, 20 Sep 2012 07:07:00 GMT

Yesterday I was received a mail from Microsoft with a subject like "Congratulations on Your Microsoft Certification!"

Microsoft certification? what?!? In first time i really think that was spam and put it on trash.

But I was remember that in June i have done 70-480 Programming in HTML5 with JavaScript and CSS3 beta exam!

I can't believe!!! ^_^ Prometric.com confirm the i have pass the exam!!

Yeah!

DeployManager - A helpful digital certificate manager tool

Blackat.NET — Wed, 18 Apr 2012 09:26:00 GMT

DeployManager is a tool written by Raffaele Rialdi for deals with digital certificates.
My first impression about this tool is....Wow! I searched a tool like this for years without finding it! ^_^

If you want to try this tool you can download at this link

A good list of programmer tools

Blackat.NET — Sat, 07 Apr 2012 09:53:00 GMT

Every day I spend 30 minutes of my time to find new and interesting blogs. Today I have found a blog of Andre Ignat, a MVP of Romania (link).
In this blog there is a very nice page with a list of programmer tools.

I think it's a good "start point" for prepare a developer machine. ;)

C# and VB.NET language specification

Blackat.NET — Mon, 26 Mar 2012 16:50:00 GMT

Hi,

If you search in your vs installation dir under subfolder Microsoft Visual Studio 10.0\VB\Specifications and Microsoft Visual Studio 10.0\VC#\Specifications you can found documents about language specificaiton.

If you have 5 minutes to spend i think it's a good reading. ;-)

Salvo.

Certificate Store Migration

Blackat.NET — Mon, 28 Nov 2011 10:11:00 GMT

Where system certificate are located?

See this http://msdn.microsoft.com/en-us/library/windows/desktop/bb204781%28v=VS.85%29.aspx

Use certificates in WCF client

Blackat.NET — Fri, 18 Nov 2011 17:30:00 GMT

This is a good tutorial for configure WCF and X.509 certificate authetication.

http://www.codeproject.com/KB/WCF/9StepsWCF.aspx

I have a problem when I have specified X509FindType attribute in clientCertificate element. The problem is that i have write the attribute with first char (X) in uppercase. The correct syntax x in lower case!!!

SSMS Tools Pack

Blackat.NET — Mon, 07 Nov 2011 17:33:00 GMT

SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, Denali CTP3 and their respective Express versions.
It contains a few upgrades to the SSMS IDE that I thought were missing.

For other info see http://www.ssmstoolspack.com/

Programming like making music

Blackat.NET — Thu, 12 Aug 2010 09:29:00 GMT

This morning, while I was driving to work, a think was made in my mind. In this days I'm learning how to play classic guitar, and I was think: what kind of difference there are between make music and make software?. I think that there is no difference. If you compare music with programming, there are 7 notes (DO, RE, MI, FA, SOL, LA,SI) for making music while in computer programming we are a set of principal statements (IF,LOOPS,TYPES,ASSIGNMENTS) for making software. If you make music you need a musical instrument (guitar, violin,ecc..) and a sequence of notes (for a predeterminated execution time). If you make software you need a good programming language as instrument (C#,VB.NET,JavaScript,ecc..) and make a sequence (in certain case a very long sequence :-) ) of statements.

If you think to create software in this way (like music) I think that you can create a very good software in any kind of enviroment and language.

Productivity Power Tools for VS 2010 - Update Available

Blackat.NET — Thu, 29 Jul 2010 12:42:00 GMT

A new release of Productivity Power Tools is now available from Visual Studio Gallery. Here is the link to the page. I like so much this tools for Visual Studio!

Viewstate size addons for Firefox

Blackat.NET — Tue, 21 Apr 2009 12:02:00 GMT

It's a great addons for track size of Viewstate for your Web Application.

Link: http://www.kirkov.dk/projects/firefox/viewstatesize

Very helpful for me.

A very good new year...

Blackat.NET — Wed, 07 Jan 2009 22:18:16 GMT

....with a "Catastrophic Failure" error message....

For my fortune the solution was to restart Application Pool.

The Daily WTF - Curious Perversions in IT

Blackat.NET — Tue, 19 Aug 2008 20:20:00 GMT

I'm studing for MCPD exam from the training kit book and I get this link on page 227

http://thedailywtf.com/Articles/Journey_to_the_Center_of_the_Database.aspx

It's a very funny story and a very funny site.

Function Parameter Constraint

Blackat.NET — Wed, 25 Jun 2008 22:01:02 GMT

As a developer every day I find myself in situations where I have to write different methods for purposes of any kind. Generally, I write methods that take into one or more input parameters and return a particular result

Problems arise when my colleagues use the methods that I write. In particular, the biggest problems occur when they are specified in input values that are not valid for the execution of method.

Ok. I know that I can test each parameter before the execution of the real first instruction but it's a very frustration for a developer like me.

I think that can be nicely to have a mode for define at syntax level a constraint for a parameter of a method.

Something like :

<BetweenContraint(i,0,100)> _
Public Function TakeIntegerBetween0And100(ByVal i As Integer)

There is already something like this or I invented the wheel?

I know only looking for on Google or with a comment of some blog reader.

I have got Microsoft Usb Key

Blackat.NET — Sun, 06 Apr 2008 11:50:51 GMT

I have got Microsoft Usb Key during presentation of new Microsoft products in Catania (Sicily - Italy) last 18 March.

It's a 2 GB memory. I tried to use it with Ready Boost feature of Windows Vista but does not work.