csharpin.blogspot.com
Programând C#: Virusii, messengerul si clinicile particulare
http://csharpin.blogspot.com/2011/04/virusii-messengerul-si-clinicile.html
Miercuri, 6 aprilie 2011. Virusii, messengerul si clinicile particulare. Printre pietenii de pe YM, am si un contact de la o clinica particulara din Iasi. Cand aveam nevoie de o programare, mi-era muuult mai simplu sa o fac pe messenger, decat la telefon. Dar, cum "virusurile" informatici au pus stapanire pe calculatorul din "front office", clinica s-a pricopsit cu o problema de PR, de care nu prea vrea sa scape prea curand. Abonați-vă la: Postare comentarii (Atom). TakeFive - what an extension. Round Up...
csharpin.blogspot.com
Programând C#: Table Per Hierarchy Inheritance with Column Discriminator and Associations used in Derived Entity Types
http://csharpin.blogspot.com/2011/06/table-per-hierarchy-inheritance-with.html
Sâmbătă, 25 iunie 2011. Table Per Hierarchy Inheritance with Column Discriminator and Associations used in Derived Entity Types. I'm starting with a new and empty Entity Model. As a first step I Update Model from Database and add only the InvoiceLine and Product tables. I'm check the “Pluralize or singularize generated object names” and “Include foreign key columns in model”. 1right-click the design surface, select Add- Entity, name it ProductLine and set the BaseType to InvoiceLine. 8right-click the des...
csharpin.blogspot.com
Programând C#: CKEditor m.lang.contextmenu is undefined
http://csharpin.blogspot.com/2011/08/ckeditor-mlangcontextmenu-is-undefined.html
Marți, 23 august 2011. CKEditor m.lang.contextmenu is undefined. I got the error m.lang.contextmenu is undefined. While I was installing CKEditor on an ASP .Net website and trying to use a minimum setup. I supposed the "ckeditor/lang/en.js" is enough, but, as pointed here. The editor doesn't download en.js by default, so it needs to be set on config.js. CKEDITOR.editorConfig = function (config) {. Config.language = en.js;. 15 ianuarie 2013, 07:01. The problem seems to be from the detectio mechanism.
csharpin.blogspot.com
Programând C#: Of, Doame!
http://csharpin.blogspot.com/2011/05/of-doame.html
Joi, 26 mai 2011. Abonați-vă la: Postare comentarii (Atom). Linq To Objects Extension: Full Outer Join. SelectMany - projecting the index of the result. TakeFive - what an extension. Extract currency values from text with T-SQL. The link saga on ASP .Net. Generate class from a LINQ projection. MS-SQL script to generate update statements for rtrim and ltrim. Update between two tables when there is no relation between them. CKEditor m.lang.contextmenu is undefined. Practical Example for Abstract Classes.
csharpin.blogspot.com
Programând C#: Update between two tables when there is no relation between them
http://csharpin.blogspot.com/2011/10/update-between-two-tables-when-there-is.html
Luni, 10 octombrie 2011. Update between two tables when there is no relation between them. I needed a SQL statement which fills the null values from the second column of #T1 table with values from #T2(C1). There is no foreign key or match between the columns of those two tables. I found two approaches:. Create table #T1 (C1 varchar(10), T2C1 varchar(10). Create table #T2 (C1 varchar(10). Insert into #T1 values ('A1', '1'). Insert into #T1 values ('A2', null). Insert into #T1 values ('A3', null). Create t...
csharpin.blogspot.com
Programând C#: Linq To Objects Extension: Full Outer Join
http://csharpin.blogspot.com/2012/02/linq-to-objects-extension-full-outer.html
Luni, 27 februarie 2012. Linq To Objects Extension: Full Outer Join. I need a report which shows a comparison of the sales of each service with the previous year. Some services might be new and they don't appear in the previous year, others might be put off and so there are no sales for them in the current year. There can be services sold in both periods. So I need a full outer join:. Public static IEnumerable TResult FullOuterJoin TOuter, TInner, TKey, TResult. This IEnumerable TOuter outer,. Yield retu...
csharpin.blogspot.com
Programând C#: Remotely Install EntityFramework 4.1 with psexec and gacutil
http://csharpin.blogspot.com/2011/07/remotely-install-entityframework-41.html
Miercuri, 27 iulie 2011. Remotely Install EntityFramework 4.1 with psexec and gacutil. I updated an website to use EntityFramework 4.1 Update 1. While I had no problems installing it on my dev machine, on the production machine the installer wasn't able to install the EntityFramework.dll on GAC. The reason is simple, there is no SDK installed. I can't RDC on the production server, but I have a hidden shared folder, named "adrian$". To install EntityFramework on the production machine I needed psexec.
csharpin.blogspot.com
Programând C#: MS-SQL script to generate update statements for rtrim and ltrim
http://csharpin.blogspot.com/2011/10/ms-sql-script-to-generate-update.html
Miercuri, 12 octombrie 2011. MS-SQL script to generate update statements for rtrim and ltrim. Recently I did a bulk insert into a table from a CSV file and this data had trailing spaces. I didn't notice until some email addresses look like weren't valid. I read this article which explains when the data is trimed or not. Since I had many columns to update I needed to find another solution to write/generate the update statements for "update table set column = rtrim(ltrim(column) ". For xml path (' ). Remot...
csharpin.blogspot.com
Programând C#: Generate class from a LINQ projection
http://csharpin.blogspot.com/2011/10/generate-class-from-linq-projection.html
Vineri, 28 octombrie 2011. Generate class from a LINQ projection. Using System.Linq;. Using Microsoft.CSharp;. Using System.CodeDom;. Public static class QueryExtensions. Public static string GetClassDefinition T (this IQueryable T query, string className). Var type = typeof(T);. Var sb = new StringBuilder();. SbAppendLine(string.Format(public class {0}, className) ;. Using (var provider = new CSharpCodeProvider(). Foreach ( var prop in type.GetProperties(). Replace(System., String.Empty);. Public decima...
csharpin.blogspot.com
Programând C#: Working with TIME type in SQL and ASP .Net
http://csharpin.blogspot.com/2011/06/working-with-time-type-in-sql-and-asp.html
Vineri, 3 iunie 2011. Working with TIME type in SQL and ASP .Net. Scenario: a teacher schedules his courses on a random different dates in the near future, but he always know the start time. For sample in the current week he can schedule a course for Tuesday and Friday, at 08:00 AM. In a database there would be the following tables:. 1 course (title, summary, .). 2 c ourse schedule(course id, location, start time). Where data about that schedule is preserved( ie. location). Type from SQL Server. Convert(...