c#- dependency injection, oops -encapsulation, abstraction vs interface, access modifiers, sealed class vs private class, filters, routes, constant vs readonly vs static, ref vs out sql- index, sp vs function, null vs is null, optimise. code -- 1. Table:tblFru, columnName: Name, values: Apple, Orange Table:tblVeg, columnName:Name, values: Brinjal, Cauliflower Output: "Apple - Brinjal" "Apple - Cauliflower" "Orange - Brinjal" "Orange - Cauliflower" Select from tblFru cross join tblVeg 2. who don't have an address. t- employ -name t-add -for(e) Select name from e left join add on e.id=add.EID where add=null 3. salary -t 3rd high with x as ( Select *, Row_number over (partition by s order by a) from ) 4. try { throw new ArgumentNullException(); } catch(Exception ex) { throw new ArgumentNullException(); } catch(ArgumentNullException ex) { throw new ArgumentNullException(); } 5. Public int Add(int a, int b) { return a+b; } Public int Add(long a, long b) { return a+b; } Add(1,2) 6. Public int Add(int a, int b) { return a+b; } Public string Add(int a, int b) { return "a+b"; } String s = Add(1,2) 7. Interface IA { Int Add(int a, int b) } Interface IB { Int Add(int a, int b) } Class C: IA, IB { int Add (int a, int b) { return (a+b); } } 8. int a=2;, int b=3; ,* ,pre for ( var i=1; i
