/// <summary>
/// 创建一个数据提供者实例
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="repUri"></param>
/// <returns></returns>
public static T Create <T>(string connStr) where T : class
{
T instance = null;
try
{
Assembly asm = Assembly.GetExecutingAssembly(); // Assembly.Load("LJH.Inventory.DAL");
if (asm != null)
{
foreach (Type t in asm.GetTypes())
{
if (t.IsClass && !t.IsAbstract)
{
foreach (Type inter in t.GetInterfaces())
{
if (inter == typeof(T))
{
Stream stream = asm.GetManifestResourceStream("LJH.Inventory.DAL.LinqProvider.Inventory.xml");
MappingSource mappingSource = XmlMappingSource.FromStream(stream);
instance = Activator.CreateInstance(t, connStr, mappingSource) as T;
return(instance);
}
}
}
}
}
}
catch
{
}
throw new Exception(string.Format("没有找到 {0} ,请确保 {1} 已经存在!", typeof(T).FullName, typeof(T).FullName));
}
// Temp constructor till I get IOC wired up
public ProcessLogViewModel()
{
var databaseConfigFileName = "EdhLogViewer.database.config";
var installationDirectory = @"c:\Dev\EdhLogViewer\DataAccess";
var databaseConfig = System.IO.Path.Combine(installationDirectory, databaseConfigFileName);
var mappingSource = XmlMappingSource.FromUrl(databaseConfig);
EdhLogDataContext = new EdhLogDataContext("Data Source=EDHDBSIT01,65000;Initial Catalog=ODS_SIT01;Integrated Security=True", mappingSource, false, 60);
RetrieveByProcessNameCommand = new DelegateCommand <string>(new Action <string>(i =>
{
LogMessages = new ObservableCollection <ProcessLog>(EdhLogDataContext.NameStartsWithQuery(i));
OnPropertyChanged("LogMessages");
}));
RetrieveByParamsCommand = new DelegateCommand <QueryParamsViewModel>(new Action <QueryParamsViewModel>(i =>
{
var queryParams = new QueryParams();
queryParams.ProcessName = i.ProcessName;
queryParams.StartDate = i.FromDateTime;
queryParams.EndDate = i.ToDateTime;
LogMessages = new ObservableCollection <ProcessLog>(EdhLogDataContext.ParamsQuery(queryParams));
OnPropertyChanged("LogMessages");
}));
QueryParamsViewModel = new QueryParamsViewModel();
//LogMessages = new ObservableCollection<ProcessLog> (EdhLogDataContext.NameStartsWithQuery("1000"));
}
public override void CreateDatabase()
{
//writer = new StreamWriter("c:/Oracle.txt", false);
var constr = string.Format(string.Format("Data Source=vpc1;User ID={0};password={1}", "System", "test"));
var xmlMapping = XmlMappingSource.FromStream(GetType().Assembly.GetManifestResourceStream("Test.Northwind.Oracle.Odp.map"));
var database = new OdpOracleNorthwind(constr, xmlMapping)
{
Log = Console.Out
}; //new OdpOracleNorthwind(constr) { Log = Console.Out };//
if (database.DatabaseExists())
{
database.DeleteDatabase();
}
try
{
database.CreateDatabase();
}
catch (Exception)
{
database.Log.Flush();
database.Log.Close();
throw;
}
finally
{
database.Dispose();
}
}
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);
}
//[TestMethod]
public void TestTableMappingName()
{
var xmlMapping = XmlMappingSource.FromUrl("Northwind.Oracle.map");
var model = xmlMapping.GetModel(typeof(NorthwindDemo.NorthwindDatabase));
var metaTable = model.GetTable(typeof(NorthwindDemo.Contact));
Assert.AreEqual("Contacts", metaTable.TableName);
}
public DatabaseFixture()
{
var databaseConfigFileName = "AnalyticViewer.database.config";
var installationDirectory = @"c:\Dev\AnalyticsViewer\AvDataAccess";
var databaseConfig = System.IO.Path.Combine(installationDirectory, databaseConfigFileName);
var mappingSource = XmlMappingSource.FromUrl(databaseConfig);
AvDataContext = new AvDataContext("Data Source=lonbscadsqlbl01;Initial Catalog=CADIS_E2E01;Integrated Security=True", mappingSource, false, 30);
}
public override NorthwindDatabase CreateDataBaseInstace()
{
var xmlMapping = XmlMappingSource.FromStream(typeof(SQLiteTest).Assembly.GetManifestResourceStream("Test.Northwind.SQLite.map"));
writer = Console.Out;
return(new SQLiteNorthwind(DbFileName)
{
Log = writer
}); //xmlMapping
}
public static ParkDataContext CreateParking(string connStr)
{
System.Diagnostics.Debug.Assert(!string.IsNullOrEmpty(connStr), "没有找到有效的数据库连接!");
Stream stream = typeof(ParkDataContextFactory).Assembly.GetManifestResourceStream("Ralid.Park.DAL.LinqDataProvider.ParkingMapping.xml");
MappingSource mappingSource = XmlMappingSource.FromStream(stream);
ParkDataContext parking = new ParkDataContext(connStr, mappingSource);
//parking.Log = System.Console.Out;
return(parking);
}
/// <summary>
/// Initializes a new instance of the <see cref="XmlMappingSourceManager"/> class.
/// </summary>
/// <param name="mappingStream">
/// The mapping stream.
/// </param>
public XmlMappingSourceManager(Stream mappingStream)
{
using (MemoryStream memoryStream = ReadAllToMemoryStream(mappingStream))
{
this.NoAssociationsMappingSource = CreateNoAssociationsMappingSource(memoryStream);
memoryStream.Position = 0;
this.MappingSource = XmlMappingSource.FromStream(memoryStream);
}
}
public override NorthwindDatabase CreateDataBaseInstace()
{
var xmlMapping = XmlMappingSource.FromStream(GetType().Assembly.GetManifestResourceStream("Test.Northwind.Oracle.Odp.map")); //XmlMappingSource.FromUrl("Northwind.Oracle.Odp.map");
writer = Console.Out;
return(new OdpOracleNorthwind("Data Source=vpc1;Persist Security Info=True;User ID=Northwind;Password=Test;", xmlMapping)
{
Log = writer
});
}
public override NorthwindDatabase CreateDataBaseInstace()
{
writer = Console.Out;
var xmlMapping = XmlMappingSource.FromStream(GetType().Assembly.GetManifestResourceStream("Test.Northwind.MySql.map"));
return(new MySqlNorthwind(CreateConnection().ConnectionString)
{
Log = writer
}); //xmlMapping
}
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);
}
}
public void TestInitialize()
{
var xmlMapping = XmlMappingSource.FromStream(typeof(SQLiteTest).Assembly.GetManifestResourceStream("Test.Northwind.Access.map"));
//db = new AccessNorthwind("C:/Northwind.mdb");
//db = new AccessNorthwind("C:/Northwind.mdb", xmlMapping);
//db = new SQLiteNorthwind("C:/Northwind.db3");
db = new MySqlNorthwind(MySqlNorthwind.CreateConnection("root", "test", "Northwind", "localhost", 3306).ConnectionString);
db.Log = Console.Out;
}
public override NorthwindDemo.NorthwindDatabase CreateDataBaseInstace()
{
var writer = Console.Out;
//var xmlMapping = XmlMappingSource.FromUrl("Northwind.Firebird.map");
var xmlMapping = XmlMappingSource.FromStream(GetType().Assembly.GetManifestResourceStream("Test.Northwind.Firebird.map"));
//return new FirebirdNorthwind("C:/Northwind.FDB") { Log = writer };
return(new FirebirdNorthwind("User=SYSDBA;Password=masterkey;Database=Northwind;DataSource=localhost;ServerType=0")
{
Log = writer
});
}
public virtual void RegisterInstances()
{
AppConfiguration = Container.Resolve <IAppConfiguration>();
var connectionString = AppConfiguration.DatabaseConnection;
var mappingSource = XmlMappingSource.FromUrl(AppConfiguration.DatabaseConfigFilename);
var timeout = AppConfiguration.DatabaseTimeout;
repository = new AvDataContext(connectionString, mappingSource, false, timeout);
Container.RegisterInstance <IUnitOfWork>(repository);
}
public static XmlMappingSource GetMapping()
{
if (_Mapping == null)
{
using (Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("HL.DomainModel.DataMapping.OperationalMap.xml"))
{
_Mapping = XmlMappingSource.FromStream(stream);
}
}
return(_Mapping);
}
/// <summary>
/// Gets mapping to initialize Linq2Sql data context.
/// </summary>
/// <remarks>
/// Fixture expects the linq2sql implementation contains one and only embedded resource file
/// with mapping configuration.
/// </remarks>
protected virtual MappingSource GetMapping()
{
var executingAssembly = Assembly.GetAssembly(typeof(CustomerRepository));
var customerMappingFileName =
(from r in executingAssembly.GetManifestResourceNames().AsEnumerable()
where r.EndsWith(".linq2sql.xml")
select r).Single();
var customerMappingFile = executingAssembly.GetManifestResourceStream(customerMappingFileName);
return(XmlMappingSource.FromStream(customerMappingFile));
}
public override NorthwindDatabase CreateDataBaseInstace()
{
var xmlMapping = XmlMappingSource.FromUrl("Northwind.SQL2000.map");
writer = Console.Out;
var constr = @"Data Source=vpc1\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;PASSWORD=test";
var builder = new SqlConnectionStringBuilder(constr);
return(new Sql2000Northwind(new SqlConnection(builder.ToString()))
{
Log = writer
}); //, xmlMapping
}
public DatabaseFixture()
{
if (UseFakeContext)
{
EdhLogDataContext = new EdhLogFakeDataContext();
}
else
{
var databaseConfigFileName = "EdhLogViewer.database.config";
var installationDirectory = @"c:\Dev\EdhLogViewer\DataAccess";
var databaseConfig = System.IO.Path.Combine(installationDirectory, databaseConfigFileName);
var mappingSource = XmlMappingSource.FromUrl(databaseConfig);
EdhLogDataContext = new EdhLogDataContext("Data Source=EDHDBSIT01,65000;Initial Catalog=ODS_SIT01;Integrated Security=True", mappingSource, false, 30);
}
}
private AdventureWorks2008DataContext GetContext()
{
if (_mappingSourceFromXmlFile == null)
{
var modelAssembly = typeof(AdventureWorks2008DataContext).Assembly;
var resourceStream = modelAssembly.GetManifestResourceStream("AdventureWorks2008.AdventureWorks2008Mappings.xml");
_mappingSourceFromXmlFile = XmlMappingSource.FromStream(resourceStream);
}
// pass in sql connection to make sure the profiler gathers the right information
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
var connection = factory.CreateConnection();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString.SQL Server (SqlClient)"].ConnectionString;
return(new AdventureWorks2008DataContext(connection, _mappingSourceFromXmlFile));
}
public override DataMapper CreateDataMapper()
{
if (mappingSource == null)
{
var mapping = Assembly.GetExecutingAssembly().GetManifestResourceStream(
"NailsFramework.Tests.Persistence.LinqToSql.TestModel.Mappings.xml");
mappingSource = XmlMappingSource.FromStream(mapping);
mapping.Dispose();
}
var linq2Sql = new NailsFramework.Persistence.LinqToSql
{
MappingSource = mappingSource
};
return(linq2Sql);
}
/// <summary>
/// 1) SQLMetal /Server:(localdb)\MSSQLLocalDB /Database:BookLibrary /Namespace:LinqToSqlMetal /Code:BookLibrary.CS /Map:BookLibrary.XML /Pluralize /Functions /Sprocs /Views
/// this command generate sqlmetal files to work with database it has all required syntaxes and create according to it
/// for more : http://msdn2.microsoft.com/en-us/library/bb386987.aspx.
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
string connectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=BookLibrary;Integrated Security=True";
//Creating xml mapping
XmlMappingSource mappingSource = XmlMappingSource.FromUrl(@"C:\Users\Sumitkiran.Gaurav\source\repos\LinqToSqlMetal\LinqToSqlMetal\BookLibrary.XML");
// creating datacontext
BookLibrary bookLibraryContext = new BookLibrary(connectionString, mappingSource);
IEnumerable <Bookdata> result = from book in bookLibraryContext.Bookdatas
where book.Title.Contains("India")
select book;
foreach (Bookdata book in result)
{
Console.WriteLine(book);
}
}
public void GetCreateTableCommandTest()
{
LicenseManager.CurrentContext.SetSavedLicenseKey(typeof(ALinq.Access.AccessDbProvider), "ansiboy" + Environment.NewLine + "QO77626437CFA2FE9E");
//var obj = LicenseManager.CreateWithContext(typeof (ALinq.Access.AccessDbProvider), new LicenseContext());
//Console.Write(obj);
var mapping = XmlMappingSource.FromStream(GetType().Assembly.GetManifestResourceStream("Test.Northwind.Access.map"));
var db = new AccessNorthwind("c:/nrothwind.mdb", mapping);
var target = new DatabaseSqlBuilder((SqlProvider)db.Provider);
MetaTable table = db.Mapping.GetTable(typeof(Category));
//string expected = string.Empty;
string actual;
actual = target.GetCreateTableCommand(table);
//Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
Console.WriteLine(actual);
}
public static void Initialize(TestContext testContext)
{
//var type = typeof(SQLiteTest);
//var path = type.Module.FullyQualifiedName;
//var filePath = Path.GetDirectoryName(path) + @"\ALinq.SQLite.lic";
//File.Copy(@"E:\ALinqs\ALinq1.8\Test\ALinq.SQLite.lic", filePath);
var xmlMapping = XmlMappingSource.FromStream(typeof(SQLiteTest).Assembly.GetManifestResourceStream("Test.Northwind.SQLite.map"));
writer = new StreamWriter(LogFileName, false);
var database = new SQLiteNorthwind(DbFileName)
{
Log = writer
}; //, xmlMapping
if (!database.DatabaseExists())
{
database.CreateDatabase();
database.Connection.Close();
}
}
public static AttendanceDataContext Createattendance(string connStr)
{
System.Diagnostics.Debug.Assert(!string.IsNullOrEmpty(connStr), "没有找到有效的数据库连接!");
IDbConnection connection = null;
Stream stream = typeof(AttendanceDataContextFactory).Assembly.GetManifestResourceStream("LJH.Attendance.DAL.LinqDataProvider.DataMapping.xml");
XmlMappingSource mappingSource = XmlMappingSource.FromStream(stream);
string sqlType = AppSettings.CurrentSetting.GetSQLType();
if (sqlType == "MSSQL")
{
connection = new SqlConnection(AppSettings.CurrentSetting.GetConnectString());
}
else if (sqlType == "SQLITE")
{
connection = new SQLiteConnection(AppSettings.CurrentSetting.GetConnectString());
}
System.Diagnostics.Debug.Assert(connection != null, "没有找到有效的数据库连接!");
AttendanceDataContext attendance = new AttendanceDataContext(connection, mappingSource);
//attendance.Log = System.Console.Out;
return(attendance);
}
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);
}
/// <summary>
/// Creates the mapping source with no associations in mapping.
/// </summary>
/// <param name="mappingStream">
/// The mapping stream.
/// </param>
/// <returns>
/// The mapping source with no associations
/// </returns>
private static MappingSource CreateNoAssociationsMappingSource(Stream mappingStream)
{
var stripAssociationsTransform = new XslCompiledTransform();
Stream sheetStream = Assembly.GetExecutingAssembly().GetManifestResourceStream("LogicSoftware.DataAccess.Repository.Mapping.StripAssociations.xslt");
using (XmlReader sheetReader = XmlReader.Create(sheetStream))
{
stripAssociationsTransform.Load(sheetReader);
}
using (var buffer = new MemoryStream())
{
using (XmlReader mappingReader = XmlReader.Create(mappingStream))
{
stripAssociationsTransform.Transform(mappingReader, new XsltArgumentList(), buffer);
}
buffer.Position = 0;
return(XmlMappingSource.FromStream(buffer));
}
}
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.");
}
private static MappingSource GetMapping()
{
var mapping = XmlMappingSource.FromStream(typeof(EfzNorthwind).Assembly.GetManifestResourceStream("NorthwindDemo.Northwind.Efz.map"));
return(mapping);
}
public SQLiteNorthwind(string conn, XmlMappingSource mapping)
: base(conn, mapping)
{
}
