Redis (REmote DIctionay Server) is a very popular open-source, networked, in-memory, key-value data store, sometimes referred to as a data structure server which also comes with optional durability. Redis is well known for high performance, flexibility, provides a rich set of data structures, and a simple straightforward API.
PM> Update-Package
PM> Install-Package MahApps.Metro -Pre PM> Install-Package MahApps.Metro.Resources PM> Install-Package EntityFramework PM> Install-Package structuremap PM> Install-Package PropertyChanged.Fody PM> Install-Package MvvmLight PM> Install-Package Microsoft.SqlServer.Compact
The path is not valid. Check the directory for the database. [ Path = D:\...\bin\Debug\Db\db.sdf ]
<connectionStrings>
<clear/>
<add name="MyWpfFrameworkContext"
connectionString="Data Source=|DataDirectory|\Db\db.sdf;Max Buffer Size=30720;File Mode=Read Write;"
providerName="System.Data.SqlServerCE.4.0" />
</connectionStrings> 
An interview with Anders Hejlsberg: his origin story; how he created TypeScript, C#, Delphi and Turbo Pascal; open source; his daily workflow; his thoughts on AI, Solidity, Rust, and more.
HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize();
using System.Collections.Generic;
namespace EF_Sample06.Models
{
public class Department
{
public int DepartmentId { get; set; }
public string Name { get; set; }
//Creates Employee navigation property for Lazy Loading (1:many)
public virtual ICollection<Employee> Employees { get; set; }
}
}
namespace EF_Sample06.Models
{
public class Employee
{
public int EmployeeId { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
//Creates Department navigation property for Lazy Loading
public virtual Department Department { get; set; }
}
}
using System.Data.Entity;
using EF_Sample06.Models;
namespace EF_Sample06.DataLayer
{
public class Sample06Context : DbContext
{
public DbSet<Department> Departments { set; get; }
public DbSet<Employee> Employees { set; get; }
}
}
using System.Collections.Generic;
using System.Data.Entity.Migrations;
using EF_Sample06.Models;
namespace EF_Sample06.DataLayer
{
public class Configuration : DbMigrationsConfiguration<Sample06Context>
{
public Configuration()
{
AutomaticMigrationsEnabled = true;
AutomaticMigrationDataLossAllowed = true;
}
protected override void Seed(Sample06Context context)
{
var employee1 = new Employee { FirstName = "f name1", LastName = "l name1" };
var employee2 = new Employee { FirstName = "f name2", LastName = "l name2" };
var employee3 = new Employee { FirstName = "f name3", LastName = "l name3" };
var employee4 = new Employee { FirstName = "f name4", LastName = "l name4" };
var dept1 = new Department { Name = "dept 1", Employees = new List<Employee> { employee1, employee2 } };
var dept2 = new Department { Name = "dept 2", Employees = new List<Employee> { employee3 } };
var dept3 = new Department { Name = "dept 3", Employees = new List<Employee> { employee4 } };
context.Departments.Add(dept1);
context.Departments.Add(dept2);
context.Departments.Add(dept3);
base.Seed(context);
}
}
}
void ExportMappings(DbContext context, string edmxFile)
{
var settings = new XmlWriterSettings { Indent = true };
using (XmlWriter writer = XmlWriter.Create(edmxFile, settings))
{
System.Data.Entity.Infrastructure.EdmxWriter.WriteEdmx(context, writer);
}
}
using (var db = new Sample06Context())
{
ExportMappings(db, "mappings.edmx");
}
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using EF_Sample06.DataLayer;
using EF_Sample06.Models;
namespace EF_Sample06
{
class Program
{
static IList<Employee> FindEmployees(string fName, string lName, bool byName, bool byLName)
{
using (var db = new Sample06Context())
{
IQueryable<Employee> query = db.Employees.AsQueryable();
if (byLName)
{
query = query.Where(x => x.LastName == lName);
}
if (byName)
{
query = query.Where(x => x.FirstName == fName);
}
return query.ToList();
}
}
static void Main(string[] args)
{
// note: remove this line if you received : create database is not supported by this provider.
HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize();
Database.SetInitializer(new MigrateDatabaseToLatestVersion<Sample06Context, Configuration>());
var list = FindEmployees("f name1", "l name1", true, true);
foreach (var item in list)
{
Console.WriteLine(item.FirstName);
}
}
}
}
var list = FindEmployees("f name1", "l name1", true, true);
SELECT [Extent1].[EmployeeId] AS [EmployeeId],
[Extent1].[FirstName] AS [FirstName],
[Extent1].[LastName] AS [LastName],
[Extent1].[Department_DepartmentId] AS [Department_DepartmentId]
FROM [dbo].[Employees] AS [Extent1]
WHERE ([Extent1].[LastName] = 'l name1' /* @p__linq__0 */)
AND ([Extent1].[FirstName] = 'f name1' /* @p__linq__1 */)
using (var db = new Sample06Context())
{
var dept1 = db.Departments.Find(1);
if (dept1 != null)
{
Console.WriteLine(dept1.Name);
foreach (var item in dept1.Employees)
{
Console.WriteLine(item.FirstName);
}
}
}
SELECT [Limit1].[DepartmentId] AS [DepartmentId],
[Limit1].[Name] AS [Name]
FROM (SELECT TOP (2) [Extent1].[DepartmentId] AS [DepartmentId],
[Extent1].[Name] AS [Name]
FROM [dbo].[Departments] AS [Extent1]
WHERE [Extent1].[DepartmentId] = 1 /* @p0 */) AS [Limit1]
SELECT [Extent1].[EmployeeId] AS [EmployeeId],
[Extent1].[FirstName] AS [FirstName],
[Extent1].[LastName] AS [LastName],
[Extent1].[Department_DepartmentId] AS [Department_DepartmentId]
FROM [dbo].[Employees] AS [Extent1]
WHERE ([Extent1].[Department_DepartmentId] IS NOT NULL)
AND ([Extent1].[Department_DepartmentId] = 1 /* @EntityKeyValue1 */)
using (var db = new Sample06Context())
{
foreach (var dept in db.Departments)
{
Console.WriteLine(dept.Name);
foreach (var item in dept.Employees)
{
Console.WriteLine(item.FirstName);
}
}
}
There is already an open DataReader associated with this Command which must be closed first
<connectionStrings>
<clear/>
<add
name="Sample06Context"
connectionString="Data Source=(local);Initial Catalog=testdb2012;Integrated Security = true;MultipleActiveResultSets=True;"
providerName="System.Data.SqlClient"
/>
</connectionStrings>
using (var db = new Sample06Context())
{
foreach (var dept in db.Departments.Include(x => x.Employees))
{
Console.WriteLine(dept.Name);
foreach (var item in dept.Employees)
{
Console.WriteLine(item.FirstName);
}
}
}
SELECT [Project1].[DepartmentId] AS [DepartmentId],
[Project1].[Name] AS [Name],
[Project1].[C1] AS [C1],
[Project1].[EmployeeId] AS [EmployeeId],
[Project1].[FirstName] AS [FirstName],
[Project1].[LastName] AS [LastName],
[Project1].[Department_DepartmentId] AS [Department_DepartmentId]
FROM (SELECT [Extent1].[DepartmentId] AS [DepartmentId],
[Extent1].[Name] AS [Name],
[Extent2].[EmployeeId] AS [EmployeeId],
[Extent2].[FirstName] AS [FirstName],
[Extent2].[LastName] AS [LastName],
[Extent2].[Department_DepartmentId] AS [Department_DepartmentId],
CASE
WHEN ([Extent2].[EmployeeId] IS NULL) THEN CAST(NULL AS int)
ELSE 1
END AS [C1]
FROM [dbo].[Departments] AS [Extent1]
LEFT OUTER JOIN [dbo].[Employees] AS [Extent2]
ON [Extent1].[DepartmentId] = [Extent2].[Department_DepartmentId]) AS [Project1]
ORDER BY [Project1].[DepartmentId] ASC,
[Project1].[C1] ASC
public class Sample06Context : DbContext
{
public Sample06Context()
{
this.Configuration.LazyLoadingEnabled = false;
}
public class Department
{
public int DepartmentId { get; set; }
public string Name { get; set; }
public ICollection<Employee> Employees { get; set; }
public Department()
{
Employees = new HashSet<Employee>();
}
}
This post provides a simple IValueConverter implementation that makes use of the framework type converters in order to convert between a large range of source / target types. This converter can be used both within bindings and in code-behind to give more concise property setters.
Blog ID BlogID int Title nvarchar(250) Tags nvarchar(500)
Blog Tags Tbl BlogID int TagID int
CREATE TABLE sal_emp (
name text,
pay_by_quarter integer[],
schedule text[][]
); Npgsql.EntityFrameworkCore.PostgreSQL
- Adblock Plus 2.1.2 http://adblockplus.org/en/ - Add to Search Bar 2.0 http://firefox.maltekraus.de/extensions/add-to-search-bar - Calculator 1.1.27 http://code.google.com/p/firefoxcalculator/ - CodeBurner for Firebug 1.6 http://tools.sitepoint.com/codeburner - ColorZilla 2.8.1 http://www.colorzilla.com/ - Cookies Manager+ 1.5.1 https://addons.mozilla.org/en-US/firefox/addon/cookies-manager-plus/ - CSS Usage 0.2.9 http://spaghetticoder.org/cssusage/ - DOM Inspector 2.0.12 http://www.mozilla.org/projects/inspector/ - Extension List Dumper 1.15.2 http://www.sogame.cat/ - File Title 1.4 http://www.jasnapaka.com/mozilla/filetitle/ - Firebug 1.10.2 http://www.getfirebug.com/ - FireDiff 1.2.0 http://www.incaseofstairs.com/firediff - Firefinder for Firebug 1.04 http://robertnyman.com/firefinder/ - FireFTP 2.0.7 http://fireftp.mozdev.org - FireQuery 1.2 http://firequery.binaryage.com - Forecastfox 2.2.1 http://www.getforecastfox.com/ - Greasemonkey 1.0 http://www.greasespot.net/ - HighlightAll 1.6 http://jgoudey.free.fr/highlightall/ - HttpFox 0.8.11 http://code.google.com/p/httpfox/ - IranianCalendar 3.1.20081222 http://www.alavi.us/jcal/ - Linky 3.0.0 http://gemal.dk/mozilla/linky.html - MeasureIt 0.4.10 http://frayd.us/ - Open With 5.2.1 http://www.darktrojan.net/software/addons/openwith/ - PDF Download 3.0.0.2 http://www.pdfdownload.org - Pixel Perfect 1.7.1 http://www.pixelperfectplugin.com/ - Pray Times! 1.1.7 http://praytimes.org/ - Proxy Selector 0.80.7 http://addons.mozilla.org - Right-Click-Link 1.1.5 http://rickardandersson.com/ - SearchPreview 5.9 http://searchpreview.de/ - Server Spy 0.2.1 http://www.jacquet80.eu/mozilla/exts/ServerSpy/ - Session Manager 0.7.9 http://sessionmanager.mozdev.org/ - Show MyIP 0.8 http://www.tsql.de/download/firefox-addon-ip-adresse-ip-address - Show Picture 2.7 https://addons.mozilla.org/en-US/firefox/addon/show-picture/?src=api - Showcase 0.9.5.8 http://showcase.uworks.net/ - Snap Links Plus 2.2.1 http://snaplinks.mozdev.org/ - Sothink Web Video Downloader for Firefox 6.8 http://www.web-video-downloader.com - Speed Dial 0.9.6.8 http://speeddial.uworks.net/ - SQLite Manager 0.7.7 http://sqlite-manager.googlecode.com/ - Stylish 1.2.6 http://userstyles.org/ - Subtitle Matcher 0.3.4 http://ds6.ovh.org/hashsubtitles/subtitle_matcher_firefox_extensions.php - Tilt 1.0.1 http://blog.mozilla.com/tilt/ - UnMHT 5.7.5 http://www.unmht.org/unmht/en_index.html - UnPlug 2.050 http://unplug.dbatley.com/ - User Agent Switcher 0.7.3 http://chrispederick.com/work/user-agent-switcher/ - View Source Chart 3.05 http://zigrat.com - Viewstate Size 1.0.4 http://www.kirkov.dk/projects/firefox/viewstatesize - Web Developer 1.2.1 http://chrispederick.com/work/web-developer/firefox/ - YSlow 3.1.4 http://developer.yahoo.com/yslow
KeyValue Databases e.g Riak, Redis, Berkeley DB, CouchBase etc. Document Databases e.g MongoDB, CounchDB, OrientDB etc. Column Family Databases e.g Cassandra, HBase, Amazon DynamoDB etc. Graph Databases e.g Neo4J, OrientDB etc.
در اکثر موارد در یک Landscape عملیاتی، چنانچه به تجمیع و انتقال داده‌ها از بانک‌های اطلاعاتی مختلف نیاز باشد، از SSIS Package اختصار (SQL Server Integration Service) استفاده میشود و معمولاً با تعریف یک Job در سطح SQL Server به اجرای Package در زمانهای مشخص می‌پردازند. چنانچه در موقعیتی لازم باشد که از طریق برنامه کاربردی توسعه یافته، به اجرای Package مبادرت ورزیده شود و البته نخواهیم Job تعریف شده را از طریق کد برنامه، اجرا کنیم و در واقع این امکان را داشته باشیم که همانند یک رویه ذخیره شده تعریف شده در سطح بانک اطلاعاتی به اجرای عمل فوق بپردازیم، یک راه حل میتواند تعریف یک CLR Stored Procedures باشد. در این مقاله به بررسی این موضوع پرداخته میشود، در ابتدا لازم است به بیان تئوری موضوع پرداخته شود (قسمت‌های 1 الی 5) در ادامه به ذکر پیاده سازی روش پیشنهادی پرداخته میشود.
• command-line ابزار خط فرمان dtexec.exeتوجه: همچنین یک Package را در زمان طراحی در Business Intelligence Development Studio) BIDS) میتوان اجرا نمود.
• ابزار اجرائی پکیج dtexecui.exe
• استفاده از SQL Server Agent job
| مقدار | توصیف |
| 0 | Package با موفقیت اجرا شده است. |
| 1 | Package با خطا مواجه شده است. |
| 3 | Package در حال اجرا توسط کاربر لغو شده است. |
| 4 | Package پیدا نشده است. |
| 5 | Package بارگذاری نشده است. |
| 6 | ابزار با یک خطای نحوی یا خطای معنایی در خط فرمان برخورد کرده است. |
dtexec /option [value] [/option [value]]…
• تعدادی از گزینه‌های خط فرمان dtsrun به طور مستقیم در dtexec معادل دارند برای مثال نام Server و نام Package.
• تعدادی از گزینه‌های dtsrun به طور مستقیم در dtexec معادل ندارند.
• تعدادی گزینه‌های خط فرمان جدید dtsexec وجود دارد که در ویژگی‌های جدید Integration Service پشتیبانی میشود.
dtexec /sq <Package Name> /ser <Server Name>
dtexec /dts “\File System\<Package File Name>”
dtexec /f “c:\<Package File Name>” /l “DTS.LogProviderTextFile; <Log File Name>”
dtexec /server “<Server Name>” /sql “<Package Name>” / user “ssis” /Password “ssis@ssis” /De “123”
| Write action | Read action | Role |
| Import packages Delete own packages Delete all packages Change own package roles Change all package roles * به نکته رجوع شود | Enumerate own packages Enumerate all packages View own packages View all packages Execute own packages Execute all packages Export own packages Export all packages Execute all packages in SQL Server Agent | db_ssisadmin or sysadmin |
| Import packages Delete own packages Change own package roles | Enumerate own packages Enumerate all packages View own packages Execute own packages Export own packages | db_ssisltduser |
| None | Enumerate all packages View all packages Execute all packages Export all packages Execute all packages in SQL Server Agent | db_ssisoperator |
| Stop all currently running packages | View execution details of all running packages | Windows administrators |
- Component Service را باز نمایید ( در Run عبارت dcomcnfg را تایپ کنید).مجوز دسترسی Lunch به منظور شروع و خاتمه سرویس، اعطا یا رد میشود و مجوز دسترسیActivation به منظور متصل شدن به سرویس، اعطا (grant) یا رد (deny) میشود.
- گره Component Service را باز کنید، گره Computer و سپس My Computer را باز نمایید و روی DCOM Config کلیک نمایید.
- گره DCOM Config را باز کنید و از لیست برنامه هایی که می‌توانند پیکربندی شوند MsDtsServer را انتخاب کنید.
- روی Properties برنامه MsDtsServer رفته و قسمت Security را انتخاب کنید.
- در قسمت Lunch and Activation Permissions، مورد Customize را انتخاب و سپس روی Edit کلیک نمایید تا پنجره Lunch Permission باز شود.
- در پنجره Lunch Permission، کاربران را اضافه و یا حذف کنید و مجوزهای مناسب را به کاربران یا گروه‌های مناسب نسبت دهید. مجوزهای موجود عبارتند از Local Lunch، Remote Lunch، Local Activation و Remote Activation .
- در قسمت Access Permission مراحل فوق را به منظور نسبت دادن مجوزهای مناسب به کاربران یا گروه‌های مناسب انجام دهید.
- سرویس Integration را Restart کنید.
Partial Public Class StoredProcedures
'------------------------------------------------
'exec dbo.Spc_NtDtexec 'Package','ssis','ssis@ssis','1234512345'
'------------------------------------------------
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub Spc_NtDtexec(ByVal PackageName As String, _
ByVal UserName As String, _
ByVal Password As String, _
ByVal Decrypt As String)
Dim p As New System.Diagnostics.Process()
p.StartInfo.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe"
p.StartInfo.RedirectStandardOutput = True
p.StartInfo.Arguments = "/sql " & PackageName & " /User " & UserName & " /Password " & Password & " /De " & Decrypt
p.StartInfo.UseShellExecute = False
p.Start()
p.WaitForExit()
Dim output As String
output = p.StandardOutput.ReadToEnd()
Microsoft.SqlServer.Server.SqlContext.Pipe.Send(output)
End Sub
End Class SP_CONFIGURE 'clr enabled',1 GO RECONFIGURE
ALTER DATABASE <Database Name> SET TRUSTWORTHY ON GO RECONFIGURE
USE <Database Name> GO CREATE ASSEMBLY [RunningPackage] AUTHORIZATION [dbo] FROM 'C:\RunningPackage.dll' WITH PERMISSION_SET = UNSAFE Go CREATE PROCEDURE [dbo].[Spc_NtDtexec] @PackageName [nvarchar](50), @UserName [nvarchar](50), @Password [nvarchar](50), @Decrypt [nvarchar](50) WITH EXECUTE AS CALLER AS EXTERNAL NAME [RunningPackage].[RunningPackage.StoredProcedures].[Spc_NtDtexec] GO
Private Sub ExecutePackage()
Dim oSqlConnection As SqlClient.SqlConnection
Dim oSqlCommand As SqlClient.SqlCommand
Dim strCnt As String = String.Empty
strCnt = "Data Source=" & txtServer.Text & ";User ID=" & txtUsername.Text & ";Password=" & txtPassword.Text & ";Initial Catalog=" & cmbDatabaseName.SelectedValue.ToString() & ";"
Try
oSqlConnection = New SqlClient.SqlConnection(strCnt)
oSqlCommand = New SqlClient.SqlCommand
With oSqlCommand
.Connection = oSqlConnection
.CommandType = System.Data.CommandType.StoredProcedure
.CommandText = "dbo.Spc_NtDtexec"
.Parameters.Clear()
.Parameters.Add("@PackageName", System.Data.SqlDbType.VarChar, 50)
.Parameters.Add("@UserName", System.Data.SqlDbType.VarChar, 50)
.Parameters.Add("@Password", System.Data.SqlDbType.VarChar, 50)
.Parameters.Add("@Decrypt", System.Data.SqlDbType.VarChar, 50)
.Parameters("@PackageName").Value = txtPackageName.Text.Trim()
.Parameters("@UserName").Value = txtUsername.Text.Trim()
.Parameters("@Password").Value = txtPassword.Text.Trim()
.Parameters("@Decrypt").Value = txtDecrypt.Text.Trim()
End With
If (oSqlCommand.Connection.State <> System.Data.ConnectionState.Open) Then
oSqlCommand.Connection.Open()
oSqlCommand.ExecuteNonQuery()
System.Windows.Forms.MessageBox.Show("Success")
End If
If (oSqlCommand.Connection.State = System.Data.ConnectionState.Open) Then
oSqlCommand.Connection.Close()
End If
Catch ex As Exception
MessageBox.Show(ex.Message, "Error")
End Try
End Sub 'ExecutePackage