فهرستی از keyboard shortcutها را میتوانید در اینجا ببینید:
https://code.visualstudio.com/docs/getstarted/keybindings
https://code.visualstudio.com/docs/getstarted/keybindings
public void AddNewCustomers(params Customer[] customers)
{
using (ISession session = _factory.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
foreach (var data in customers)
session.Save(data);
session.Flush();
transaction.Commit();
}
}
}
using System.Collections.Generic;
using System.Linq;
using NHibernate;
using NHibernate.Linq;
using NHSample1.Domain;
namespace ConsoleTestApplication
{
class CLinqTest : NHibernateContext
{ }
}
using System.Collections.Generic;
using System.Linq;
using NHibernate;
using NHibernate.Linq;
using NHSample1.Domain;
namespace ConsoleTestApplication
{
class CLinqTest : NHibernateContext
{
ISessionFactory _factory;
public CLinqTest(ISessionFactory factory)
{
_factory = factory;
}
public List<Customer> GetAllCustomers()
{
using (ISession session = _factory.OpenSession())
{
var query = from x in session.Linq<Customer>() select x;
return query.ToList();
}
}
}
}
static void Main(string[] args)
{
using (ISessionFactory session = Config.CreateSessionFactory(
MsSqlConfiguration
.MsSql2008
.ConnectionString("Data Source=(local);Initial Catalog=HelloNHibernate;Integrated Security = true")
.ShowSql()
))
{
var customer1 = new Customer()
{
FirstName = "Vahid",
LastName = "Nasiri",
AddressLine1 = "Addr1",
AddressLine2 = "Addr2",
PostalCode = "1234",
City = "Tehran",
CountryCode = "IR"
};
var customer2 = new Customer()
{
FirstName = "Ali",
LastName = "Hasani",
AddressLine1 = "Addr..1",
AddressLine2 = "Addr..2",
PostalCode = "4321",
City = "Shiraz",
CountryCode = "IR"
};
var customer3 = new Customer()
{
FirstName = "Mohsen",
LastName = "Shams",
AddressLine1 = "Addr...1",
AddressLine2 = "Addr...2",
PostalCode = "5678",
City = "Ahwaz",
CountryCode = "IR"
};
CDbOperations db = new CDbOperations(session);
db.AddNewCustomers(customer1, customer2, customer3);
CLinqTest lt = new CLinqTest(session);
foreach (Customer customer in lt.GetAllCustomers())
{
Console.WriteLine("Customer: LastName = {0}", customer.LastName);
}
}
Console.WriteLine("Press a key...");
Console.ReadKey();
}
public List<Customer> GetCustomersByCity(string city)
{
using (ISession session = _factory.OpenSession())
{
var query = from x in session.Linq<Customer>()
where x.City == city
select x;
return query.ToList();
}
}
foreach (Customer customer in lt.GetCustomersByCity("Shiraz"))
{
Console.WriteLine("Customer: LastName = {0}", customer.LastName);
}
using System.Linq;
using NHibernate;
using NHibernate.Linq;
using NHSample1.Domain;
namespace ConsoleTestApplication
{
class SampleContext : NHibernateContext
{
public SampleContext(ISession session)
: base(session)
{ }
public IOrderedQueryable<Customer> Customers
{
get { return Session.Linq<Customer>(); }
}
public IOrderedQueryable<Employee> Employees
{
get { return Session.Linq<Employee>(); }
}
public IOrderedQueryable<Order> Orders
{
get { return Session.Linq<Order>(); }
}
public IOrderedQueryable<OrderItem> OrderItems
{
get { return Session.Linq<OrderItem>(); }
}
public IOrderedQueryable<Product> Products
{
get { return Session.Linq<Product>(); }
}
}
}
using System.Collections.Generic;
using System.Linq;
using NHibernate;
using NHSample1.Domain;
namespace ConsoleTestApplication
{
class CSampleContextTest
{
ISessionFactory _factory;
public CSampleContextTest(ISessionFactory factory)
{
_factory = factory;
}
public List<Customer> GetCustomersByCity(string city)
{
using (ISession session = _factory.OpenSession())
{
using (SampleContext db = new SampleContext(session))
{
var query = from x in db.Customers
where x.City == city
select x;
return query.ToList();
}
}
}
}
}
"frameworks": { "netcoreapp1.0": {} },
"frameworks": { "netcoreapp1.0": { "imports": [ "dotnet5.6", "portable-net45+win8" ] } },
using System; using System.Collections.Generic; namespace Test { public class Table { public Header Header { set; get; } public IList<Cell> Cells { set; get; } public float Width { set; get; } } public class Header { public string Title { set; get; } public DateTime Date { set; get; } public IList<Cell> Cells { set; get; } } public class Cell { public string Caption { set; get; } public float Width { set; get; } } }
using System; using System.Collections.Generic; namespace Test { public class TableApi { public Table CreateTable(Action<TableCreator> action) { var creator = new TableCreator(); action(creator); return creator.TheTable; } } public class TableCreator { readonly Table _theTable = new Table(); internal Table TheTable { get { return _theTable; } } public void Width(float value) { _theTable.Width = value; } public void AddHeader(Action<HeaderCreator> action) { _theTable.Header = ... } public void AddCells(Action<CellsCreator> action) { _theTable.Cells = ... } } }
using System; using System.Collections.Generic; namespace Test { public class CellsCreator { readonly IList<Cell> _cells = new List<Cell>(); internal IList<Cell> Cells { get { return _cells; } } public void AddCell(string caption, float width) { _cells.Add(new Cell { Caption = caption, Width = width }); } } public class HeaderCreator { readonly Header _header = new Header(); internal Header Header { get { return _header; } } public void Title(string title) { _header.Title = title; } public void Date(DateTime value) { _header.Date = value; } public void AddCells(Action<CellsCreator> action) { var creator = new CellsCreator(); action(creator); _header.Cells = creator.Cells; } } }
using System; using System.Collections.Generic; namespace Test { public class TableCreator { readonly Table _theTable = new Table(); internal Table TheTable { get { return _theTable; } } public void Width(float value) { _theTable.Width = value; } public void AddHeader(Action<HeaderCreator> action) { var creator = new HeaderCreator(); action(creator); _theTable.Header = creator.Header; } public void AddCells(Action<CellsCreator> action) { var creator = new CellsCreator(); action(creator); _theTable.Cells = creator.Cells; } } public class CellsCreator { readonly IList<Cell> _cells = new List<Cell>(); internal IList<Cell> Cells { get { return _cells; } } public void AddCell(string caption, float width) { _cells.Add(new Cell { Caption = caption, Width = width }); } } public class HeaderCreator { readonly Header _header = new Header(); internal Header Header { get { return _header; } } public void Title(string title) { _header.Title = title; } public void Date(DateTime value) { _header.Date = value; } public void AddCells(Action<CellsCreator> action) { var creator = new CellsCreator(); action(creator); _header.Cells = creator.Cells; } } }
var data = new TableApi().CreateTable(table => { table.Width(1); table.AddHeader(header=> { header.Title("new rpt"); header.Date(DateTime.Now); header.AddCells(cells=> { cells.AddCell("cell 1", 1); cells.AddCell("cell 2", 2); }); }); table.AddCells(tableCells=> { tableCells.AddCell("c 1", 1); tableCells.AddCell("c 2", 2); }); });