public void AttributeLicense1()
{
DataContext context;
var mapping = XmlMappingSource.FromXml(
@"<Database Name=""Northwind"" Provider=""ALinq.Firebird.FirebirdProvider, ALinq.Firebird, Version=1.2.7.0, Culture=Neutral, PublicKeyToken=2b23f34316d38f3a"" xmlns=""http://schemas.microsoft.com/linqtosql/mapping/2007"">
</Database>
");
context = new MyDataContext("", mapping);
Assert.IsNotNull(((SqlProvider)context.Provider).License);
var license = (ALinqLicenseProvider.LicFileLicense)((SqlProvider)context.Provider).License;
Assert.IsFalse(license.IsTrial);
mapping = XmlMappingSource.FromXml(
@"<Database Name=""Northwind"" Provider=""ALinq.Access.AccessDbProvider, ALinq.Access, Version=1.7.9.0, Culture=neutral, PublicKeyToken=2b23f34316d38f3a"" xmlns=""http://schemas.microsoft.com/linqtosql/mapping/2007"">
</Database>
");
context = new MyDataContext("", mapping);
Assert.IsNotNull(((SqlProvider)context.Provider).License);
license = (ALinqLicenseProvider.LicFileLicense)((SqlProvider)context.Provider).License;
Assert.IsFalse(license.IsTrial);
mapping = XmlMappingSource.FromXml(
@"<Database Name=""Northwind"" Provider=""ALinq.SQLite.SQLiteProvider, ALinq.SQLite, Version=1.7.9.0, Culture=neutral, PublicKeyToken=2b23f34316d38f3a"" xmlns=""http://schemas.microsoft.com/linqtosql/mapping/2007"">
</Database>
");
context = new MyDataContext("", mapping);
Assert.IsNotNull(((SqlProvider)context.Provider).License);
license = (ALinqLicenseProvider.LicFileLicense)((SqlProvider)context.Provider).License;
Assert.IsFalse(license.IsTrial);
}
public void XmlMapping_7_2()
{
XmlMappingSource map = XmlMappingSource.FromXml(System.IO.File.ReadAllText(@"lia.xml"));
using (DataContext dataContext =
new DataContext(ConfigurationManager.ConnectionStrings["SqlConStr"].ConnectionString, map))
{
var authors = dataContext.GetTable <AuthorXml>();
ObjectDumper.Write(authors);
}
}
protected virtual MappingSource AdaptMappingSource(Type dataContextType)
{
MappingSource adaptedMappingSource;
if (dataContextType == null)
{
throw new ArgumentNullException("dataContextType");
}
if (!AdaptedMappingSources.TryGetValue(dataContextType, out adaptedMappingSource))
{
adaptedMappingSource = XmlMappingSource
.FromXml(UnderlyingMappingSource
.GetModel(dataContextType)
.Adapt(ModelAdapter)
.ToString());
AdaptedMappingSources.Add(dataContextType, adaptedMappingSource);
}
return(adaptedMappingSource);
}
public void Load_LinqToSql_container()
{
const string l2sConnectionStringName =
"Ignorance.Testing.Properties.Settings.AdventureWorksConnectionString";
string l2sConnectionString =
ConfigurationManager.ConnectionStrings[l2sConnectionStringName].ConnectionString;
// get the map
var map = XmlMappingSource.FromXml(Properties.Resources.AdventureWorks);
var container = new UnityContainer()
.RegisterType <AdventureWorks>(
new InjectionConstructor(l2sConnectionString, map))
.RegisterType <IWork, Ignorance.LinqToSql.Work>(
new InjectionConstructor(typeof(AdventureWorks)))
.RegisterType(typeof(IStore <Department>),
typeof(Ignorance.Testing.Data.LinqToSql.DepartmentStore))
.RegisterType(typeof(IStore <>), typeof(Ignorance.LinqToSql.Store <>));
Create.Container = (UnityContainer)container;
Assert.IsTrue(true, "Failed to load the LINQ to SQL IoC Container.");
}
static void Main(string[] args)
{
XmlMappingSource xms = XmlMappingSource.FromXml(File.ReadAllText("Test.map"));
Test context = new Test(connString, xms);
// 单表查询
var query =
from testMain in context.Test_main
select testMain;
foreach (Test_main main in query)
{
Console.WriteLine("Main[{0}, {1}]", main.Id, main.Value);
}
// 关联查询
var query2 =
from testSub in context.Test_sub
where testSub.Test_main.Value == "ONE"
select testSub;
foreach (Test_sub sub in query2)
{
Console.WriteLine("Sub[{0}, {1}]", sub.Id, sub.Value);
}
// 插入.
Test_main main3 = new Test_main();
main3.Id = 3;
main3.Value = "Three";
context.Test_main.InsertOnSubmit(main3);
context.SubmitChanges();
Console.WriteLine("INSERT FINISH!");
Console.ReadLine();
// 更新.
var newTestMain =
(from testMain in context.Test_main
where testMain.Id == 3
select testMain).First();
newTestMain.Value = "Three3";
context.SubmitChanges();
Console.WriteLine("UPDATE FINISH!");
Console.ReadLine();
// 单表查询 TOP 2
var queryTop2 =
(from testMain in context.Test_main
orderby testMain.Id descending
select testMain).Take(2);
foreach (Test_main main in queryTop2)
{
Console.WriteLine("Main[{0}, {1}]", main.Id, main.Value);
}
// 删除.
context.Test_main.DeleteOnSubmit(newTestMain);
context.SubmitChanges();
Console.WriteLine("DELETE FINISH!");
Console.ReadLine();
}
/// <summary>
/// Creates an XmlMappingSource generated from the fluent mapping information
/// </summary>
/// <returns>An XmlMappingSource object</returns>
public virtual MappingSource CreateMappingSource()
{
return(XmlMappingSource.FromXml(CreateDocument().ToString()));
}