[HowTo] [SQL] Insert data in a column with default value with Linq
Il suffit de jouer avec les paramêtres AutoSync et IsDbGenerated dans les propriétés du champs que l’on veut traiter. il suffit de mettre la valeur AutoSync.OnInsert dans la propriété AutoSync et true dans la valeur IsDbGenenrated Voici plus de détails : [Column( Storage=”_Id”, AutoSync=AutoSync.OnInsert, DbType=”Int NOT NULL IDENTITY”, IsPrimaryKey=true, IsDbGenerated=true )] Ces paramètres sont accessibles […]
[MSSQL] Concatenating Rows Values in Transact-SQL
see the “The blackbox XML methods” here : https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
[HowTo] Update Autogenerated values in Linq DBML
Set field properties in DBML editor : Auto-generated = true auto-sync = always More info here http://weblogs.asp.net/zeeshanhirani/…
[HowTo] disable “unknown publisher” security message on Windows Mobile device
http://xman892.blogspot.be/2007/07/visual-studio-2008-device-security.html
[Error] Please install NETCFv35.Messages.EN.wm.cab or NETCFv35.Messages.FR.wm.cab
Damn… I’ve taken some time to find a correct way to handle this… Sometimes, when debugging windows mobile applications, i got the following message : “An error message is available for this exception but cannot be displayed because these messages are optional and are not currently installed on this device. Please install ‘NETCFv35.Messages.EN.wm.cab’ for Windows […]
[How to] backup and restore Windows 8 activation
http://forums.mydigitallife.info/threads/35737-GUIDE-How-to-backup-and-restore-Windows-8-activation
[HowTo] hide control in master page (asp.net)
http://stackoverflow.com/questions/3121915/can-i-hide-a-user-control-in-a-master-page-from-a-content-page
[HowTo] Select Top x using Linq
If you wish to make such a query : Select top 10 Foo from MyTable use the .Take(x) method : var foo = (from t in MyTable select t.Foo).Take(10); In VB LINQ has a take expression: Dim foo = From t In MyTable Take 10 Select t.Foo
[HowTo] Linq Count Granchild items from an object with .SelectMany()
Lets say you have the following structure : Product -> Zone -> Category -> Item Meaning a Product has multiple Zones with multiple Categories with multiple Items Lets say we need to select the count of items for each product in a simple distinct list of product. Linq query using .SelectMany() : xyzDataContext dc = […]