10. July 2016 15:07 by admin in
using (var db = new SqlConnection(ConfigurationManager.ConnectionStrings["TEST"].ConnectionString))
{
db.Open();
OrmLiteConfig.DialectProvider = SqlServer2012OrmLiteDialectProvider.Instance;
OrmLiteConfig.DialectProvider.NamingStrategy = new OrmLiteNamingStrategyBase();
var q = db.From<Customer>()
.Join<Customer, Order>((cust,ord)=>cust.CustomerID==ord.CustomerID)
.Join<Order,Order_Detail >((ord,orddet)=>ord.OrderID==orddet.OrderID);
var results = db.SelectMulti<Customer, Order_Detail, Order>(q);
}
23. May 2016 06:58 by admin in
When you see:
<Path to Project> : error : The Web Application <Project Name> is configured to use IIS. Unable to access the IIS metabase. You do not have sufficient privilege to access IIS web sites on your machine.
There is an easy fix:
Browse to C:\Windows\System32\inetsrv and then double-click the “config” directory. You should get this warning dialog:

Click Continue, then do the same for the C:\Windows\System32\inetsrv\config\export directory and the other directories in C:\Windows\System32\inetsrv
This should fix the issue and you will be able to load the project.
15. March 2016 13:39 by admin in
DataTable dt = ds.Tables[0];
var sponsorids = dt.Rows.OfType<DataRow>().Select(dr => (int) dr["AccountID"]).ToList();
return sponsorids;
28. August 2015 12:36 by admin in
<telerik:RadGrid ID="grdBlah" runat="server" AllowMultiRowSelection="false" AllowPaging="true"AutoGenerateColumns="False" CellPadding="0" GridLines="Both" PageSize="15" ShowFooter="false"OnPageIndexChanged="grdBlah_OnPageIndexChanged"AllowSorting="true"OnSortCommand="grdBlah_OnSortCommand"OnNeedDataSource="grdBlah_NeedDataSource"OnItemDataBound="grdBlah_OnItemDataBound"><MasterTableView ShowFooter="false"><Columns><telerik:GridTemplateColumn UniqueName="btnViewTransactionDetails"ItemStyle-Width="100" HeaderStyle-Width="100"HeaderText="Action"ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"><ItemTemplate><asp:HyperLink ID="HyperLink1" runat="server" Text="View Detail"NavigateUrl='<%#String.Format("~/Pages/TransactionDetails.aspx?ID={0}&accountID={1}", DataBinder.Eval(Container.DataItem,"transID") , hfAccountID.Value) %>'></asp:HyperLink></ItemTemplate></telerik:GridTemplateColumn></Columns></MasterTableView><ClientSettings EnablePostBackOnRowClick="true"><Selecting AllowRowSelect="true" /></ClientSettings>
</telerik:RadGrid>
This example should be self-explanatory. If there are more parameters, handle them exactly as in the example code below.