Alias /test "/Users/Michael/Projects/TestAspNetMvc/TestAspNetMvc/"
<Directory "/Users/Michael/Projects/TestAspNetMvc/TestAspNetMvc/">
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
AddMonoApplications default "/test:/Users/Michael/Projects/TestAspNetMvc/TestAspNetMvc/"
<Location /test>
SetHandler mono
</Location>
Server Error in '/htmlencoder' Application
Compilation Error
Description: Error compiling a resource required to service this request. Review your source file and modify it to fix this error.
Compiler Error Message: CS0246: The type or namespace name `Dictionary' could not be found. Are you missing a using directive or an assembly reference?
Source Error:
Line 8:
Line 9: Input
Line 10: <p><%: Html.TextArea("Encode","", new Dictionary<string,object> { { "cols", 120 }, { "rows", 12 } }) %></p>
Line 11:
Line 12:
Source File: /Library/WebServer/Documents/HtmlEncoder/Views/Encoder/Index.ascx Lines: 10, 27
Version information: Mono Runtime Version: 2.8 (tarball Thu Oct 7 12:23:27 MDT 2010); ASP.NET Version: 4.0.30319.1
<add namespace="System.Collections.Generic" />
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=152368
-->
<configuration>
<system.web>
<httpRuntime requestValidationMode="2.0" />
<compilation debug="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</assemblies>
</compilation>
<authentication mode="Forms">
<forms loginUrl="~/Account/LogOn" timeout="2880" />
</authentication>
<pages>
<namespaces>
<add namespace="System.Web.Mvc" />
<add namespace="System.Web.Mvc.Ajax" />
<add namespace="System.Web.Mvc.Html" />
<add namespace="System.Web.Routing" />
<add namespace="System.Collections.Generic" /> <!-- add this -->
</namespaces>
</pages>
</system.web>
<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules runAllManagedModulesForAllRequests="true"/>
</system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0" newVersion="2.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
Server Error in '/portal' Application Compilation Error Description: Error compiling a resource required to service this request. Review your source file and modify it to fix this error. Compiler Error Message: : at (wrapper managed-to-native) System.Reflection.MonoMethodInfo:get_method_info (intptr,System.Reflection.MonoMethodInfo&) ~/Global.asax
MonoServerPath /Library/Frameworks/Mono.framework/Commands/mod-mono-server4
MonoAutoApplication disabled
Include /etc/apache2/mod_mono.conf AddHandler mono .aspx .ascx .asax .ashx .config .cs .asmx .axd MonoAutoApplication disabled MonoApplications "/:/Library/WebServer/Documents/" Alias /portal "/Library/WebServer/Documents/HtmlEncoder/" AddMonoApplications default "/portal:/Library/WebServer/Documents/HtmlEncoder/" <Location /portal> SetHandler mono </Location> MonoServerPath /Library/Frameworks/Mono.framework/Commands/mod-mono-server4
#include <stdio.h>
int main (int argc, char *argv[])
{
unsigned long number_to_test = 42;
unsigned long mask;
printf("\nFirst: ");
for (mask = 1 << 31; mask != 0; mask >>= 1)
printf("%d " , (number_to_test & mask));
printf("\nSecond: ");
for (mask = 1 << 31; mask != 0; mask >>= 1)
printf("%d", !(number_to_test & mask));
printf("\nThird: ");
for (mask = 1 << 31; mask != 0; mask >>= 1)
{
putchar('0' + !!(number_to_test & mask));
// printf("%d", !!(number_to_test & mask));
}
printf("\nFourth: ");
for (mask = 1 << 31; mask != 0; mask >>= 1)
{
if (number_to_test & mask)
putchar('1');
else
putchar('0');
}
printf("\nFifth: ");
for (mask = 1 << 31; mask != 0; mask >>= 1)
putchar( (number_to_test & mask) ? 'Y' : 'N' );
puts("\n\nTesting boolean logic not");
printf("\n%d", ! 4);
printf("\n%d", ! 7);
printf("\n%d", ! 0);
puts("\n\nTesting boolean logic not not");
printf("\n%d", ! ! 4);
printf("\n%d", ! ! 7);
printf("\n%d", ! ! 0);
return 0;
}
First: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32 0 8 0 2 0 Second: 11111111111111111111111111010101 Third: 00000000000000000000000000101010 Fourth: 00000000000000000000000000101010 Fifth: NNNNNNNNNNNNNNNNNNNNNNNNNNYNYNYN Testing boolean logic not 0 0 1 Testing boolean logic not not 1 1 0
mono -V
Mono JIT compiler version 2.10.9 (tarball Mon May 7 20:25:51 EDT 2012) Copyright (C) 2002-2011 Novell, Inc, Xamarin, Inc and Contributors. www.mono-project.com TLS: normal SIGSEGV: normal Notification: kqueue Architecture: x86 Disabled: none Misc: debugger softdebug LLVM: yes(2.9svn-mono) GC: Included Boehm (with typed GC)
sudo mv /Library/WebServer/Documents/index.html.en /Library/WebServer/Documents/x_index.html.en
mkdir ~/swoop cd ~/swoop sudo ln -s /Library/Frameworks/Mono.framework/Commands/pkg-config /usr/bin/pkg-config curl -O http://origin-download.mono-project.com/sources/mono/mono-2.10.9.tar.bz2 tar xzf mono-2.10.9.tar.bz2 cd mono-2.10.9 ./configure make sudo make install sudo sh -c "echo '\n\nInclude /etc/apache2/mod_mono.conf' >> /etc/apache2/httpd.conf" echo "<center><img src='PoweredByMacOSXLarge.gif'><br><% int a = 7 * 6;%><%=a%> <%=new System.Random().Next()%></center>" > /Library/WebServer/Documents/index.aspx sudo /usr/sbin/apachectl restart echo 'Done'
Unhandled Exception: NHibernate.MappingException: Could not configure datastore from input stream AwesomeNHibernate.RecordCompanyDatabase.hbm.xml ---> System.Xml.XmlException: XML declaration cannot appear in this state. Line 2, position 40.
Unhandled Exception: NHibernate.Bytecode.ProxyFactoryFactoryNotConfiguredException: The ProxyFactoryFactory was not configured.
Initialize 'proxyfactory.factory_class' property of the session-factory configuration section with one of the available NHibernate.ByteCode providers.
Example:
<property name='proxyfactory.factory_class'>NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>
Unhandled Exception: NHibernate.MappingException: Could not compile the mapping document: AwesomeNHibernate.RecordCompanyDatabase.hbm.xml ---> System.InvalidOperationException: Could not find the dialect in the configuration
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace AwesomeNHibernate
{
class Program
{
static void Main(string[] args)
{
IList<Musician> musicians = SampleMusicianList();
foreach (Musician musician in musicians)
{
Console.WriteLine("*****\n{0}\n\nAge: {1}\n", musician.MusicianInfo, musician.Age);
}
Console.ReadLine();
}
static IList<Musician> SampleMusicianList()
{
return new List<Musician>
{
new Musician { MusicianId = 1, MusicianName = "Elvis Presley", BirthYear = 1935, FavoriteInstrument = "Guitar" },
new Musician { MusicianId = 2, MusicianName = "Jimi Hendrix", BirthYear = 1942, FavoriteInstrument = "Electric Guitar" },
};
}
}//Program
public class Musician
{
public int MusicianId { get; set; }
public string MusicianName { get; set; }
public int BirthYear { get; set; }
public string FavoriteInstrument { get; set; }
public int Age
{
get
{
return DateTime.Today.Year - BirthYear;
}
}
public string MusicianInfo
{
get
{
return string.Format("Musician ID: {0}\nName: {1}\nFavorite Instrument: {2}", MusicianId, MusicianName, FavoriteInstrument);
}
}
}//Musician
}//Awesome
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NHibernate;
using NHibernate.Cfg;
using System.Reflection;
namespace AwesomeNHibernate
{
class Program
{
static void Main(string[] args)
{
IList<Musician> musicians = MusicianList();
foreach (Musician musician in musicians)
{
Console.WriteLine("*****\n{0}\n\nAge: {1}\n", musician.MusicianInfo, musician.Age);
}
Console.ReadLine();
}
// Relational...
static ISession OpenSession()
{
var c = new Configuration();
c.AddAssembly(Assembly.GetCallingAssembly());
ISessionFactory f = c.BuildSessionFactory();
return f.OpenSession();
}
static IList<Musician> MusicianList()
{
using (ISession session = OpenSession())
{
IQuery query = session.CreateQuery("from Musician order by BirthYear, MusicianName");
IList<Musician> musicians = query.List<Musician>();
return musicians;
}
}
// ...Relational
}//Program
public class Musician
{
public int MusicianId { get; set; }
public string MusicianName { get; set; }
public int BirthYear { get; set; }
public string FavoriteInstrument { get; set; }
// The beauty of ORM, it allows you to offload compute-intensive routine from database to front-end(e.g. webserver) or middle-tier
public int Age
{
get
{
return DateTime.Today.Year - BirthYear;
}
}
public string MusicianInfo
{
get
{
return string.Format("Musician ID: {0}\nName: {1}\nFavorite Instrument: {2}", MusicianId, MusicianName, FavoriteInstrument);
}
}
}//Musician
}//Awesome
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true" assembly="AwesomeNHibernate" namespace="AwesomeNHibernate" >
<class name="Musician" lazy="false" table="musician">
<id name="MusicianId" column="musician_id">
<generator class="sequence">
<param name="sequence">musician_id_seq</param>
</generator>
</id>
<property name="MusicianName" column="musician_name"/>
<property name="BirthYear" column="birth_year"/>
<property name="FavoriteInstrument" column="favorite_instrument"/>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true">
<class name="AwesomeNHibernate.Musician, AwesomeNHibernate" lazy="false" table="musician">
<id name="MusicianId" column="musician_id">
<generator class="sequence">
<param name="sequence">musician_id_seq</param>
</generator>
</id>
<property name="MusicianName" column="musician_name"/>
<property name="BirthYear" column="birth_year"/>
<property name="FavoriteInstrument" column="favorite_instrument"/>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
</configSections>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory>
<property name="dialect">NHibernate.Dialect.PostgreSQLDialect</property>
<property name="connection.connection_string">Server=localhost;Database=test;User ID=postgres;Password=opensesame;</property>
<property name="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>
</session-factory>
</hibernate-configuration>
</configuration>
Note: In order for this to work in MonoDevelop, change app.config's Copy to output directory property from Do not copy to Always copy If you don't want to clutter your app.config, you can put nhibernate settings on separate file instead, NHibernate look its settings from hibernate.cfg.xml file: <?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory>
<property name="dialect">NHibernate.Dialect.PostgreSQLDialect</property>
<property name="connection.connection_string">Server=localhost;Database=test;User ID=postgres;Password=opensesame;</property>
<property name="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>
</session-factory>
</hibernate-configuration>
Likewise, change hibernate.cfg.xml's Copy to output directory property from Do not copy to Always copy. And change the OpenSession code to: static ISession OpenSession()
{
var c = new Configuration();
c.Configure(); // add this, this makes NHibernate look for its settings from hibernate.cfg.xml instead of app.config
c.AddAssembly(Assembly.GetCallingAssembly());
ISessionFactory f = c.BuildSessionFactory();
return f.OpenSession();
}
Note the c.Configure();, failing to add that code will result to: Unhandled Exception: NHibernate.MappingException: Could not compile the mapping document: AwesomeNHibernate.RecordCompanyDatabase.hbm.xml ---> System.InvalidOperationException: Could not find the dialect in the configuration
create table musician
(
musician_id serial not null primary key,
musician_name text,
favorite_instrument text,
birth_year int
);
insert into musician(musician_name, favorite_instrument, birth_year) values
('John Lennon','Guitar', 1940),
('Paul McCartney', 'Bass Guitar', 1942),
('George Harrison', 'Sitar', 1943),
('Ringo Starr', 'Drums', 1940);
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property> <property name="connection.connection_string">Data Source=.\SQLEXPRESS;Initial Catalog=RecordCompany;Trusted_Connection=yes</property> <property name="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>
<id name="MusicianId" column="musician_id">
<generator class="native"/>
</id>
musician_id int identity(1,1) not null primary key
create table musician
(
musician_id int identity(1,1) not null primary key,
musician_name varchar(max),
favorite_instrument varchar(max),
birth_year int
);
insert into musician(musician_name, favorite_instrument, birth_year) values
('Kurt Cobain','Guitar', 1967),
('Krist Novoselic', 'Bass Guitar', 1965),
('Dave Grohl', 'Sitar', 1969)
ADOException was unhandled could not execute query [ select musician0_.musician_id as musician1_0_, musician0_.musician_name as musician2_0_, musician0_.birth_year as birth3_0_, musician0_.favorite_instrument as favorite4_0_ from musician musician0_ order by musician0_.birth_year, musician0_.musician_name ] [SQL: select musician0_.musician_id as musician1_0_, musician0_.musician_name as musician2_0_, musician0_.birth_year as birth3_0_, musician0_.favorite_instrument as favorite4_0_ from musician musician0_ order by musician0_.birth_year, musician0_.musician_name]
select * from musician order by birth_year, musician_name
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
The type or namespace name 'NHibernate' could not be found (are you missing a using directive or an assembly reference?)
How to test if two NULLS are equal in SQL Server, ala-C#. Before our dear DBAs waxes philosophical that NULL = NULL is unknown, NULL <> NULL is also unknown, we must note that comparing things that results to knowns has uses, say for example we want to make audit logger in trigger code, that trigger code must be optimized. We will have database performance problem if we don't detect the field when logging changes, as this will do unconditional logging, whether the pertinent field(s) changes or not. We will also have problem in our logging logic if we cannot properly detect if there is a change that have occured in nullable field.IF new.sub_account_of <> old.sub_account_of THEN
// log changes here
ELSE
// do nothing
END
IF new.sub_account_of IS DISTINCT FROM old.sub_account_of THEN
// log changes here
ELSE
// do nothing
END
A == B NULL == NULL : True NULL == 1 : False NULL == 2 : False 1 == NULL : False 1 == 1 : True 1 == 2 : False 2 == NULL : False 2 == 1 : False 2 == 2 : True A != B NULL != NULL : False NULL != 1 : True NULL != 2 : True 1 != NULL : True 1 != 1 : False 1 != 2 : True 2 != NULL : True 2 != 1 : True 2 != 2 : False
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace NullComparison
{
class Program
{
struct Rec
{
public int? a, b;
public Rec(int? a, int? b)
{
this.a = a;
this.b = b;
}
}
static void Main(string[] args)
{
Console.WriteLine("{0,4} == {1,4}", "A", "B");
foreach (Rec r in Values())
{
Console.WriteLine("{0,4} == {1,4} : {2}",
r.a != null ? r.a.ToString() : "NULL",
r.b != null ? r.b.ToString() : "NULL",
r.a == r.b);
}
Console.WriteLine();
Console.WriteLine("{0,4} != {1,4}", "A", "B");
foreach (Rec r in Values())
{
Console.WriteLine("{0,4} != {1,4} : {2}",
r.a != null ? r.a.ToString() : "NULL",
r.b != null ? r.b.ToString() : "NULL", r.a != r.b);
}
Console.ReadLine();
}
static IEnumerable<Rec> Values()
{
yield return new Rec(null, null);
yield return new Rec(null, 1);
yield return new Rec(null, 2);
yield return new Rec(1, null);
yield return new Rec(1, 1);
yield return new Rec(1, 2);
yield return new Rec(2, null);
yield return new Rec(2, 1);
yield return new Rec(2, 2);
}
}//class Program
}//namespace NullComparison
select a,b into x_m from ( values (null,null), (null,1), (null,2), (1,null), (1,1), (1,2), (2,null), (2,1), (2,2) )as x(a,b)
select a,b ,coalesce(a = b or (a is null and b is null), false) as manual_comp ,a is not distinct from b as built_in_comp from x_m
a | b | manual_comp | built_in_comp ---+---+-------------+--------------- | | t | t | 1 | f | f | 2 | f | f 1 | | f | f 1 | 1 | t | t 1 | 2 | f | f 2 | | f | f 2 | 1 | f | f 2 | 2 | t | t (9 rows)
select a,b ,coalesce(a <> b and (a is not null or b is not null), true) as manual_comp ,a is distinct from b as built_in_comp from x_m
a | b | manual_comp | built_in_comp ---+---+-------------+--------------- | | f | f | 1 | t | t | 2 | t | t 1 | | t | t 1 | 1 | f | f 1 | 2 | t | t 2 | | t | t 2 | 1 | t | t 2 | 2 | f | f (9 rows)
IF ans != 'John' AND ans != 'Paul' AND ans != 'George' AND ans != 'Ringo' THEN
FindAnotherInterviewee
END
IF ans != 'Y' AND ans != 'N' AND ans != 'C' THEN ask again END
IF NOT(ans = 'Y' OR ans = 'N' or ans = 'C') THEN ask again END
IF NOT(ans = 'John' OR ans = 'Paul' OR ans = 'George' OR ans = 'Ringo') THEN
FindAnotherInterviewee
END
select a,b ,not coalesce(a = b or (a is null and b is null), false) as manual_comp ,a is distinct from b as built_in_comp from x_m
a | b | manual_comp | built_in_comp ---+---+-------------+--------------- | | f | f | 1 | t | t | 2 | t | t 1 | | t | t 1 | 1 | f | f 1 | 2 | t | t 2 | | t | t 2 | 1 | t | t 2 | 2 | f | f (9 rows)
select a,b ,coalesce(a = b or (a is null and b is null), false) as manual_comp ,a is not distinct from b as built_in_comp from x_m
select a,b,
case
when a = b then 1
when a is null and b is null then 1
else 0
end as mssql_manual_comp
from x_m
a b mssql_manual_comp ----------- ----------- ----------------- NULL NULL 1 NULL 1 0 NULL 2 0 1 NULL 0 1 1 1 1 2 0 2 NULL 0 2 1 0 2 2 1 (9 row(s) affected)
select a,b,
NOT
case
when a = b then 1
when a is null and b is null then 1
else 0
end as mssql_manual_comp
from x_m
select a,b,
case
when a = b then 1
when a is null and b is null then 1
else 0
end ^ 1 as mssql_manual_comp
from x_m
a b mssql_manual_comp ----------- ----------- ----------------- NULL NULL 0 NULL 1 1 NULL 2 1 1 NULL 1 1 1 0 1 2 1 2 NULL 1 2 1 1 2 2 0 (9 row(s) affected)
select a,b from x_m where a IS NOT DISTINCT FROM b
select a,b
from x_m
where
(case
when a = b then 1
when a is null and b is null then 1
else 0
end) = 1
a b ----------- ----------- NULL NULL 1 1 2 2 (3 row(s) affected)
select a,b from x_m where a IS DISTINCT FROM b
select a,b
from x_m
where
(case
when a = b then 1
when a is null and b is null then 1
else 0
end) = 0
a b ----------- ----------- NULL 1 NULL 2 1 NULL 1 2 2 NULL 2 1 (6 row(s) affected)
select a,b
from x_m
where
(
a = b
or
(a is null and b is null)
)
select a,b
from x_m
where
a <> b
or
(
not (a is null and b is null )
and ( a is null or b is null )
)
with x as
(
select a, b
from
(
values
(null,null),
(null,1),
(null,2),
(1,null),
(1,1),
(1,2),
(2,null),
(2,1),
(2,2)
)as x(a,b)
)
select *,
x.a IS DISTINCT FROM x.b as perfect,
x.a <> x.b as flawed,
a <> b
or
(
not (a is null and b is null )
and ( a is null or b is null )
)
as good_workaround,
(x.a <> x.b or x.a is null or x.b is null)
and not (x.a is null and x.b is null)
as perfect_workaround
from x;
| A | B | PERFECT | FLAWED | GOOD_WORKAROUND | PERFECT_WORKAROUND | |--------|--------|---------|--------|-----------------|--------------------| | (null) | (null) | 0 | (null) | (null) | 0 | | (null) | 1 | 1 | (null) | 1 | 1 | | (null) | 2 | 1 | (null) | 1 | 1 | | 1 | (null) | 1 | (null) | 1 | 1 | | 1 | 1 | 0 | 0 | 0 | 0 | | 1 | 2 | 1 | 1 | 1 | 1 | | 2 | (null) | 1 | (null) | 1 | 1 | | 2 | 1 | 1 | 1 | 1 | 1 | | 2 | 2 | 0 | 0 | 0 | 0 |
use master; go create database y_test; go use y_test; go create table employee ( id int not null, name varchar(100) not null, gross_salary numeric(18,4) not null default '', password varchar(100) not null default '' ); go insert into employee(id, name, gross_salary, password) select id, name, gross_salary, password from (values (1, 'Jobs', 75000, 'dashing'), (2, 'Ballmer', 30000, 'through'), (3, 'Gatez', 90000, 'the snow') ) as x(id, name, gross_salary, password); go select * from employee; go create view hr_facing_employee_record as select id+0 as id, name, gross_salary * (1 - .32 /* Darn Philippines Withholding Tax! */ ) as net_salary from employee; go select * from hr_facing_employee_record; go delete from hr_facing_employee_record where id = 2; go select * from hr_facing_employee_record; go -- won't be allowed, inserting records to database must be done in a controlled manner, i.e. must insert directly to table, for example, there might other mechanism how ID is generated/assigned, so must directly insert to table insert into hr_facing_employee_record(id,name) values(9,'Torvalds'); go select * from hr_facing_employee_record; go update hr_facing_employee_record set name = 'Gates' where id = 3; go select * from hr_facing_employee_record; go /* -- won't be allowed, password is not exposed in hr_facing_employee_record update hr_facing_employee_record set name = 'Backdoor', password = 'open sesame' where id = 3; go select * from hr_facing_employee_record; go */ -- won't be allowed, a view can protect the record integerity update hr_facing_employee_record set id = 8 where id = 3; go select * from hr_facing_employee_record; go use master; go drop database y_test; go
if [ -n "$*" ]; then
open -n "$*"
else
osascript -e 'tell app "Finder" to display dialog "PLZ DRAG AN APP 2 MULTIPLE INSTANCE" with title "MULTIPLE INSTANCE LAUNCHER" buttons { "OH HAI" } '
fi
SELECT C.CustomerID, COUNT(O.CustomerID) AS N FROM Customers C LEFT JOIN Orders O ON O.CustomerID = C.CustomerID GROUP BY C.CustomerID
var q =
from c in db.Customers
join o in db.Orders on c.CustomerID equals o.CustomerID into sr
from x in sr.DefaultIfEmpty()
group x by c.CustomerID into y
select new { y.Key, N = y.Count(t => t.CustomerID != null) };
int customerId = 7;
bool found = false;
for(int i = 0; i < orders.Length; ++i)
{
if(orders[i].CustomerId == customerId)
{
found = true;
break;
}
}
var q = from c in db.Customers
join o in db.Orders on o.CustomerID equals c.CustomerID into sr
int customerId = 7;
bool found = false;
for(int i = 0; i < orders.Length; ++i)
{
if(customerId == orders[i].CustomerId)
{
found = true;
break;
}
}
SELECT [t2].[CustomerID] AS [Key], (
SELECT COUNT(*)
FROM [Customers] AS [t3]
LEFT OUTER JOIN [Orders] AS [t4] ON [t3].[CustomerID] = [t4].[CustomerID]
WHERE ([t4].[CustomerID] IS NOT NULL) AND ((([t2].[CustomerID] IS NULL) AND ([t3].[CustomerID] IS NULL)) OR (([t2].[CustomerID] IS NOT NULL) AND ([t3].[CustomerID] IS NOT NULL) AND ([t2].[CustomerID] = [t3].[CustomerID])))
) AS [N]
FROM (
SELECT [t0].[CustomerID]
FROM [Customers] AS [t0]
LEFT OUTER JOIN [Orders] AS [t1] ON [t0].[CustomerID] = [t1].[CustomerID]
GROUP BY [t0].[CustomerID]
) AS [t2]
var q =
from c in db.Customers
join o in db.Orders on c.CustomerID equals o.CustomerID into sr
from x in sr.DefaultIfEmpty()
group x by c.CustomerID into y
select new { y.Key, N = y.Sum(t => t.CustomerID != null ? 1 : 0 )};
SELECT SUM(
(CASE
WHEN [t1].[CustomerID] IS NOT NULL THEN @p0
ELSE @p1
END)) AS [N], [t0].[CustomerID] AS [Key]
FROM [Customers] AS [t0]
LEFT OUTER JOIN [Orders] AS [t1] ON [t0].[CustomerID] = [t1].[CustomerID]
GROUP BY [t0].[CustomerID]
|
Warning 1 'Castle.Windsor.WindsorContainer.AddComponentLifeStyle(string, System.Type, Castle.Core.LifestyleType)' is obsolete: 'Use Register(Component.For(classType).Named(key)).Lifestyle.Is(lifestyle)) instead.' C:\_CODE\SportsStore\SportsStore\Controllers\WindsorControllerFactory.cs 37 17 SportsStore
container.AddComponentLifeStyle(t.FullName, t, LifestyleType.Transient);
container.Register(Component.For(t).Named(t.FullName)).LifeStyle.Is(LifestyleType.Transient));
container.Register(Component.For(t).Named(t.FullName).LifeStyle.Is(LifestyleType.Transient));
